Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
alexvalqlik
Contributor III
Contributor III

Accumulate in pivot table

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.

Labels (1)
0 Replies