
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Incorrect Sum in Pivot Table
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!
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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))"

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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))"

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It works, thanks for solving!
