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

How to Calculate the Cumulative Month sales

Could you help to tell me how to write the express to Calculate the Cumulative Month sales?

For example:

The January sales amount is 100

The February sales amount is 200

The March sales amount is 300

The result:

Month Sales
January 100
February 300      (100+200) January+February
March600      (100+200+300) January+February+March
1 Solution

Accepted Solutions
sunny_talwar

Or you can do this:

=RangeSum(Above(TOTAL Sum(Sales), 0, RowNo(TOTAL)))

View solution in original post

6 Replies
Anonymous
Not applicable
Author

Hi.

I attach you an example with a simple table, I hope will help you.

Group1.JPG

Regards.

sunny_talwar

Or you can do this:

=RangeSum(Above(TOTAL Sum(Sales), 0, RowNo(TOTAL)))

Not applicable
Author

I try your expression, it works fine. Mang thanks.

Not applicable
Author

Many thanks.

sunny_talwar

Awesome, I am glad it worked.

Best,

Sunny

Anonymous
Not applicable
Author