Hi,
Apologies if I've missed a topic, but I have a question about cumulative figures in charts.
I am trying to show my stakeholders how much work they have, this needs to add up cumulatively, but as soon as i select a year or month the calculation defaults to the first value.
In the example data below when I click 2018, the calculation restarts at 10, but I need to show 88. Business rules mean I have to show 88 because that is what we worked on in Jan 2018.
Data:
| Date | Opened | Closed | Cumu.Open | Cumu. Close |
| 2017-01 | 2 | 0 | 2 | 0 |
| 2017-02 | 4 | 0 | 6 | 0 |
| 2017-03 | 6 | 0 | 12 | 0 |
| 2017-04 | 6 | 3 | 18 | 3 |
| 2017-05 | 6 | 3 | 24 | 6 |
| 2017-06 | 6 | 4 | 30 | 10 |
| 2017-07 | 6 | 5 | 36 | 15 |
| 2017-08 | 8 | 9 | 44 | 24 |
| 2017-09 | 8 | 11 | 52 | 35 |
| 2017-10 | 8 | 12 | 60 | 47 |
| 2017-11 | 8 | 10 | 68 | 57 |
| 2017-12 | 10 | 11 | 78 | 68 |
| 2018-01 | 10 | 15 | 88 | 83 |
| 2018-02 | 10 | 19 | 98 | 102 |
| 2018-03 | 12 | 20 | 110 | 122 |
| 2018-04 | 10 | 6 | 120 | 128 |
| 2018-05 | 8 | 6 | 128 | 134 |
| 2018-06 | 8 | 6 | 136 | 140 |
| 2018-07 | 6 | 4 | 142 | 144 |
| 2018-08 | 10 | 2 | 152 | 146 |
| 2018-09 | 6 | 10 | 158 | 156 |
| 2018-10 | 8 | 6 | 166 | 162 |
| 2018-11 | 2 | 6 | 168 | 168 |
| 2018-12 | 4 | 2 | 172 | 170 |
I'd like to do this in the chart as I've lots of departments to drill down through and decades of data so creating a new table would be cumbersome. Ideally I want to reference my charts dimension and showing something like "count if <= dimesion", with the filter only affect the axis shown and not the underlying data.
Any ideas would be grateful,
Andrew
