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,

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