Pivot table totals with calculations and duplicate records

[orangebloss]

I'm using the following data to create a pivot table

There are two entries where the data is identical (Qty 5) but when added up in a straight table the correct Total Weight is calculated using 
(sum(Quantity))*[Est Weight])

(see right hand table below)

but the pivot table is giving the incorrect value of 1.065 when using the same syntax.

It will be obvious I'm sure but I can't quite get my head around it!

[Or]

sum(Quantity*[Est Weight])

Rule of thumb: If you want correct totals, make sure everything is contained within the aggregation function.

[orangebloss]

Can you expand on that?

[orangebloss]

When I include everything I still get the same incorrect answer of 1.065 

[Or]

I'd suggest you check your data load, then. Perhaps you have a Distinct keyword somewhere, or you're otherwise limiting the amount of data. Since your Qlik capture doesn't show details, it's hard to guess.