getpivotdata

[dchristo]

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]

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 here:

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