Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
March | 600 (100+200+300) January+February+March |
Or you can do this:
=RangeSum(Above(TOTAL Sum(Sales), 0, RowNo(TOTAL)))
Hi.
I attach you an example with a simple table, I hope will help you.
Regards.
Or you can do this:
=RangeSum(Above(TOTAL Sum(Sales), 0, RowNo(TOTAL)))
I try your expression, it works fine. Mang thanks.
Many thanks.
Awesome, I am glad it worked.
Best,
Sunny