I have a pivot table with a calculated field which multiplies two other fields together. Due to the nature of calculated fields, my Grand Total row is displaying the product of the sums of the items. I want it to display the sum of the products. Here's what I'm getting
Sum of Sum of Sum of
Item Qty Price Sales (Calculated Field Qty * Price)
1 2 1 2
2 4 1.5 6
3 6 3 18
Grand Total 12 5.5 66
I want the Sum of Sales column's Grand Total to be 26.