Getpivotdata

[bergen]

Can anyone tell me how if it is possible to create multiple =getpivotdata formulas at a time.

I am extracting data from a pivot table to other cells (and then hiding the pivot table).

Consider the below pivot table:

___J. Harb N. Bull S. Lee
US 100 50 77
CA 50 10 40
MX 80 40 40
CO 45 40 40
VE 5 100 50

I am then using getpivotdata to create a table below (which automotically updates every time I update the master data).

=getpivotdata("Expected Turnover in
USD";$A$8;"Name";"J. Harb";"REGION";"US")/100

Which gives me
___J. Harb N. Bull S. Lee
US 1
CA
MX
CO
VE

Now how do I fill out the rest of this table without having to press = and clicking the pivot table every time?

 

[wizz]

Hi,
you use the cells insted of name or region, but take care at the $ character:
B$8 and $A9( it's important to "block" the line or the column).

'=GETPIVOTDATA("Expected Turnover in USD";$A$8;"Name";B$8;"REGION";$A9)/100