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.
