Pivot Table: Calculated Fields

[Guest]

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]

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.