I created a Pivot Table using the above data in Sheet1:

Name Qty Price
Amy 1 0.1
Amy 2 0.2
Amy 3 0.3
Bob 4 0.4
Bob 5 0.5
Bob 6 0.6
Chris 7 0.7
Chris 8 0.8
Chris 9 0.9
Danny 10 1
Danny 11 1.1
Danny 12 1.2


To get Excel Pivot Table to compute a new culculated field called "Amount",
I proceeded to "Insert Calculated Field" using formula =Qty*Price. But when
this calculated field appeared in the Pivot Table, I got the below wrong
results, no matter how I tried.

My Pivot Table turned out like this (totally wrong math multiplication):

Name Data Total
Amy Sum of Qty 6
Sum of Amount 3.6
Bob Sum of Qty 15
Sum of Amount 22.5
Chris Sum of Qty 24
Sum of Amount 57.6
Danny Sum of Qty 33
Sum of Amount 108.9
Total Sum of Qty 78
Total Sum of Amount 608.4
======================================

Seems Excel multiplied the SUBTOTAL of Qty with Price, instead of muliplying
each record before summing up the results.

I tried with different machines & met the same problem too. What's gone
wrong? How to remedy?

Thanks in advance

--
Edmund
(Using Excel 2003)