G

#### Guest

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