Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
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
Partner - Champion III
Partner - Champion III

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