Pivot table calculated field - how to make correct Total values?

[JonnyBostrom]

I am using a Pivot table to get the total amount of orders to customer
from a database. I have built the pivot table with a calculated field
since the total amount for each order is missing in the database.

The calculated field = no of products * price per product

For each specific order Excel calculates the row correct.

For the total of each customer and for the pivot table Grand total i
seems as Excel is calculating like this:
(sum of all prices) * (sum of all numbers of products) = Total pe
customer (& Grand total)

Is there a way to change the way Excel calculates the totals?

If there is no other way - does anybody have a suggestion on how to d
a work-around for this?

I need to have the pivot table to make the calculation since it's
part of a big report package where I use the function GET.PIVOTDATA().

Thanks,
Jonn

 

[Debra Dalgleish]

You can calculate line totals in your data source (quantity*price), then
add the line total field to the data area of the pivot table.