Incorrect Sum in Pivot Table

[YHC]

Hi All,

My problem is I am getting the wrong total count in the pivot table. The total in the right is performed by pivot, and the total in the left is the selected column, they should be the same when the outcome is correct, but the values from pivot are different from the original table.
There's no duplicates value.

Could someone tell me where I'm going wrong? Following are the attached screenshots.

Thanks!

[mageste · Accepted solution]

Hi!

It seems like the expression sums the same row multiple times. Actually, you can see that every value in the expression (on the right) is equal to 24 times the value from the original table (on the left).

My guess is that you have 24 different Product IDs and the SUM expression is calculating for repeated rows. 

If it is the case, maybe just editing it to "SUM(DISTINCT FCCY_AMOUNT)" will solve it.

If not, you can try an aggr expression like "SUM(AGGR(SUM(FCCY_AMOUNT), PRODUCT))"

[YHC]

It works, thanks for solving!