getpivotdata

D

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?
 
D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top