GETPIVOTDATA


G

Guest

Does anyone have an opinion about the utility of this function? I've just
been handed a spreadsheet with a bunch of pivot tables, and a bunch of
calculations which use the GETPIVOTDATA function.

My take is it's easier just to enter the cell reference of the pivot table
value you want to use in a calculation. Am I missing something here? What
are the advantages, if any, of the GETPIVOTDATA function?

Dave
 
Ad

Advertisements

B

Bernie Deitrick

Dave,

If you change the PT, GETPIVOTDATA will still retrieve the correct data - your cell reference won't.

HTH,
Bernie
MS Excel MVP
 
G

Guest

Thanks--that's what I thought...

So it's fair to say that GETPIVOTDATA is dynamic, in the sense that using it
with a pivot table whose data is refreshed will insure that calculations
using the pviot table data are updated. Whereas a direct cell reference will
not.

This answers a bunch of questions
 
Ad

Advertisements

R

Roger Govier

Hi Dave

You can think of GetPivotData as being analogous to Index, Match but you
are giving it Fields to match against as opposed to ranges.
 

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