MrExcel Publishing
Your One Stop for Excel Tips & Solutions

cell ref. in GETPIVOTDATA function


Posted by john S. on May 17, 2001 11:08 AM

How do you string multiple cells together to grap data off a pivot table. ex: 1column with 5data feilds. The column name is in 2 cells EX: A1 = white A2= cat. the pivot column is "whitecat" now I want to grab a certain data feild. I know it looks something like this
GETPIVOTDATA(range,A1&" "&A2&" data answer)


Posted by Kevin James on May 17, 2001 1:04 PM

John,

Since a blank (used in your concat) isn't part of your data table, you won't get any matches.

Kevin

Posted by Mark W. on May 17, 2001 2:07 PM

John, the Excel Help topics for...

"Parts of a PivotTable" and
"GETPIVOTDATA worsheet function"

...may prove to be quite useful.

I guessing that what you're calling a "pivot
column" is actually a Row field item.

As Kevin suggested your formula should look something
like this...

=GETPIVOTDATA(<ref>,A1&A2&" Sum of Quantity")

...where "Sum of Quantity" is your Data field, and
&LT;ref> is any cell reference within your PivotTable.

What exactly is the layout of your PivotTable?

Posted by Mark W. on May 17, 2001 2:08 PM

Oops! Garbled response...use this instead...