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

Announcements
Register by January 31 for $300 off your Qlik Connect pass: Register Now!
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