Getpivot data dynamic reference


N

Nicawette

Hi all,

I am using the getpivotdata to retrieve data from a pivot table,
the formula contains references to cells $C$4,$D$4 for different items
of the fields of the pivot table, where the user can choose via a
dropdown menu the values.

=GETPIVOTDATA("Sum of Volume 1",'Summary 1'!$A$4,"Month",$C
$4,"Country",$D$4)

Would it be possible to do the same for the data field "Sum of Volume
1" and the pivot table name 'Summary 1'!$A$4 as I have different
pivot tables.

I tried the following formula for the pivot table name:
=GETPIVOTDATA("Sum of Volume 1","'"&G4&"'"&"!$A$4","Month",$C
$4,"Country",$D$4)
where G4="Sum of Volume 1"

but excel gives me #ref.

any idea?

thank you
 
Ad

Advertisements


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