Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning everyone, I have a question:
In pivot table I have the column 'Accumulated' which is the result of the sum of the column 'Month' and the expression I use is: rangesum (above (Sum (Sales_Neta), 0, noOfRows ()))
It works well when they are shown every day, but when I select 1 day it does not show me the accumulated or the sum of that day plus the sum of the previous days.
In figure No1. It shows that the expression works well.
In figure No2. It shows that I have selected day 4 and in this case it should show 4'195,566.98 that it would be the sum of the column 'Month' from day 1 to 4.
Can you please guide me?
Thank you so much.