Hi everyone,
Can I ask how I achieve the cumulative sum of each line below, they represent the 2 regions, South and Central?
I want the South figures to sum up in one line and the Central in another.
Ex. Central to be 4 + 1 + 12 + 6 etc those being Apr/May/June/July and the same for the South.
At the moment the RangeSum Sum Central and South together and I don't want that.
I can achieve this when I use one line only but it seems not to be working when I bring the Region Name in.
I posted a screenshot of the table with the count and range sum and how they are currently behaving.
The formula I used as "height of the line" is the following:
=RangeSum(Above(COUNT({<WORK_CODE={'HL','HDU','HUR'},CURRENT_FY={'Y'}>}DATA_UP_DT),0,RowNo()))