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
<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...
