Pivot table for calculations

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,
 
D

Debra Dalgleish

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rows disappear in pivot table 1
How do I perform extended calculations in a Pivot Table in Excel 2 4
Getpivot data dynamic reference 1
Select a cell in a Pivot table 2
how do I copy calculations outside of a pivot table 1
can i add subtotals to subtotals in a pivot table? 1
Pivot Table Calculated field error 1
Pivot Table Comparisons in Excel 2007 2

Top