Pivot table for calculations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top