Pivot Table: Calculated Fields

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

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