Pivot Table: Calculated Fields
 

I've create a calculated field eg. price x quantity on a pivot table.
however, at the bottom where it sums up the column, it shows the sum of price
only. Is there something I need to do in order for it to sum the "calculated"
data? Thanks.

Pivot Table: Calculated Fields
 

You should calculate the total price (price x quantity) for each row in
the source data table. Then, add that field to the pivot table's data
area, and you should get the correct grand total.

Natalie wrote:
I've create a calculated field eg. price x quantity on a pivot table.
however, at the bottom where it sums up the column, it shows the sum of price
only. Is there something I need to do in order for it to sum the "calculated"
data? Thanks.


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