Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Accumulation second dimension

I have two dimensions (customers, year) and I need to show accumulation sales (attached image)

How to count it?

Thanks

3 Replies
er_mohit
Master II
Master II

rangesum(above(sum(Fieldname),0,rowno()))

Gysbert_Wassenaar

Depends on how you want to accumulate. You can try something like rangesum(above(sum(Sales),0,rowno())) to accumulate over customers or rangesum(before(sum(Sales),0,columnno())) to accumulate over years.


talk is cheap, supply exceeds demand
Not applicable
Author

I want to accumulate over customers for one year