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!
Rule of thumb: If you want correct totals, make sure everything is contained within the aggregation function.
Can you expand on that?
When I include everything I still get the same incorrect answer of 1.065
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.