GETPIVOTDATA - Listing the Row Entries

[Jim-in-I]

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?

 

[Mark W.]

No, GETPIVOTDATA only returns values summarized in a PivotTable's DATA area.
This message was edited by Mark W. on 2002-09-16 08:33

 

[Jim-in-I]

Thanks Mark,
I resolved the issue by creating a dynamic range name for the Pivot Table data, then used
=MCONCAT(range,CHAR(10))
to summarize the data values in one cell.

Thanks for stomping on the brakes before I drove too far down that road.