a
I think 2 possible can be tried:
- Hide data you do not want to show but that is part of the dataset (otherwise cumulatives are not properly calculated)
- Feed a second query with the first cumulative one and try if you can use the proper filter on the 2nd query
These are just my 2 cents, can't really test if they will 'cut the cake'
a
The blankness is due to not setting an explicit aggregate for the measure..