Calculated field returns incorrect grand total

[baascore]

I have used a calculated field to multiply price by quantity
Totals of calculated field in pivot table give incorrect results.
How can I show the correct values in pivot?

Thanks.

[Naveed Raza]

try this attached file let me know

i thing in pivot table you can enter only max 10 formulaes...

hope this will work

[Izandol]

Calculated field calculates SUM(Price)*SUM(Quantity) rather than SUM(Price*Quantity). It is easier to do the calculation in your data table and simply add the fields to the pivot table. (Your data is not in ideal format for a pivot table - Month should be one field rather than separate fields for each month.)