GETPIVOTDATA - Listing the Row Entries

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?
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
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

Board Regular
Joined
Sep 10, 2002
Messages
180
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.
 

Forum statistics

Threads
1,144,769
Messages
5,726,183
Members
422,661
Latest member
foxleinlady

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top