Question

1
Replies
604
Views
Mokshash Member since 2016 1 post
Scotiabank
Posted: 3 years ago
Last activity: 3 years 1 month ago
Closed
Solved

How to create a report that populate Cumulative Sum of Resolved cases per month

I am looking for an option to add a column in report definition which does a cumulative sum / running total.
For example, I have a following report,

------------------------------------
| Month | Resolved Cases |
------------------------------------
| 01 | 200 |
| 02 | 150 |
| 03 | 100 |
| 04 | 250 |
------------------------------------

Now, I am looking for option to add a cumulative sum of resolved cases,

-----------------------------------------------------
| Month | Resolved Cases | Cumulative |
-----------------------------------------------------
| 01 | 200 | 200 |
| 02 | 150 | 350 |
| 03 | 100 | 450 |
| 04 | 250 | 700 |
-----------------------------------------------------

Please advice on how to achieve cumulative sum.

Reporting
Moderation Team has archived post
Share this page LinkedIn