MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by John S. on February 13, 2001 6:16 AM

I need to know the correct way to get pivot data. EX:
Row: Apples,Red,Washington,
Data: Sum of Sales
I need to get the sum of the Red Apples Sales from this pivotdata using ref. cells
getpivotdata(Pivot1,A1&" "&B1 Sum of sales)

this is not working. help thanks

Posted by Mark W. on February 13, 2001 6:55 AM

John, if you leave "Washington" as a row item
you'll need to turn on Subtotals for your field
(Color?) that includes the "Red" and "Green" items.
Once you've done that you can use:

=GETPIVOTDATA(Pivot1,A1&" "&B1)

Alternately, you could eliminate the Subtotals
mentioned above and move the field (State?)
with the "Washington" item to the COLUMN area.