getpivotdata
 

I am trying to reference m pivot table on another tab; but am having issues
with the formula

=GETPIVOTDATA(SUMMARY!A5,$A$5,"Processor","Paula Brown")

What am I doing wrong?

getpivotdata
 

The first argument should be the data field name, with the pivot table
cell reference in the second argument. For example:

=GETPIVOTDATA("Sum of Qty",SUMMARY!$A$5,"Processor","Paula Brown")

If you turn on the Generate GetPivotData feature, the formula will be
automatically created when you click on a data cell in the pivot table.
There are instructions he

http://www.contextures.com/xlPivot06.html

dchristo wrote:
I am trying to reference m pivot table on another tab; but am having issues
with the formula

=GETPIVOTDATA(SUMMARY!A5,$A$5,"Processor","Paula Brown")

What am I doing wrong?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html