software

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(quot;Totalquot;,$A$6,quot;Regionquot;,I8)/GETPIVOTDATA(quot;Unitsquot;,$A$6,quot;Regionquot;,I8)

where cell I8 contains the name of the first region.

Santiago Boeri wrote:
gt; I am trying to perform calculations using the data directly from a pivot table.
gt; For instance, i want to divide one of the fields by another field but
gt; outside the table. GETPIVOTDATA does not help at all.
gt;
gt; Thanks,--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html