Pivot table for calculations
 

I am trying to perform calculations using the data directly from a pivot table.
For instance, i want to divide one of the fields by another field but
outside the table. GETPIVOTDATA does not help at all.

Thanks,

Pivot table for calculations
 

You can link to the pivot table cells, e.g.:

=C7/D7

or use cell references in the GETPIVOTDATA formula, instead of text, e.g.:


=GETPIVOTDATA("Total",$A$6,"Region",I8)/GETPIVOTDATA("Units",$A$6,"Region",I8)

where cell I8 contains the name of the first region.

Santiago Boeri wrote:
I am trying to perform calculations using the data directly from a pivot table.
For instance, i want to divide one of the fields by another field but
outside the table. GETPIVOTDATA does not help at all.

Thanks,


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html