Jim-in-I
Board Regular
- Joined
- Sep 10, 2002
- Messages
- 180
I am trying to capture the individual row entries from a Pivot Table, and display them in another cell. I can use GETPIVOTDATA to summarize the Totals, but I can not resolve the problem of listing the name in each row.
Example of Pivot Table:
Count of Name | Total
-----------------------
John | 12
Frank | 10
Adam | 17
-----------------------
Total | 39
I need to display the Names (John, Frank, Adam); can this be done with GETPIVOTDATA?
Example of Pivot Table:
Count of Name | Total
-----------------------
John | 12
Frank | 10
Adam | 17
-----------------------
Total | 39
I need to display the Names (John, Frank, Adam); can this be done with GETPIVOTDATA?