Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Pivor table with two dimensions : "Month1" and "Month2".
And one expression :Sum(Sales)
"Month2" is pivoted : i.e, it appears as Columns.
Now I want to sum the values row-wise and display them in the last column.
Enabling "Show Pratial Sums" option is not resulting in correct values.
Please find the below output that is required.
Jan | Feb | Mar | Total | |
---|---|---|---|---|
Jan | 2 | 5 | 8 | 15 |
Feb | 10 | 25 | 6 | 41 |
Mar | 5 | 8 | 5 | 18 |
Apr | 3 | 4 | 6 | 13 |
I don't see why it would not show you the partial sum, would you be able to share a sample where this is not working?
Hi,
There is not specific reason why it is not showing correct value. might be in your data model due to join it is giving you wrong sum
Just modify your expression like below and try
sum(Aggr(sum(Sales),dim1,dim2))
Regards,
The expression Sum(Sales) is resulting in correct values.
The only thing is that i need the sum in the last column say(Total).
It should show it once you have enable the 'Show Partial Sum' on the presentation tab