Hi Edmund

I'm afraid that that is the way that Calculated Fields work within Pivot
Tables.
The Sub-totals and Totals use the Sum of Qty * Sum of Price, and not
Sum(Qty*Price)

In the case of AMY, it uses sum of Amy's qty = 6 * Sum of Amy's price =0.6
to give a result of 3.6
Similarly for all of the others, till you get to Total, where sum of Qty is
78 * Sum of price 7.8 = 604.8

You need to carry out the calculation in the source table.
Remove your calculated field
In the source table, add another column (D) with =B2*C2 copied down, and
titled Amount

Add Name, Qty, Price to the Row area.
Add Amount to the Data area and you will se the correct results.
--
Regards
Roger Govier



"Edmund" wrote in message
...
You may download my sample file (size 16kb only) from the below link & see
for yourself.

http://www.mediafire.com/?cjjoyzwvfzx

Eagerly awaiting your response. Thanks !

--
Edmund
(Using Excel 2000 & 2003)