Get Free Trial

Running totals reset

Maxime Flamant asked on July 19, 2018

I’m playing with a dataset involving dates and month based quantities and I’m trying to add a calculated value that would contains cumulative counts over the whole period. 
Please see in attached files what I got so far.
As you can see, it looks like the running totals are based on the first dimension (year). 
Is there a way I can configure running totals to be computed globally (not reset in 2019 in this example)?
Thank you,

1 answer

Ian Sadovy Ian Sadovy Flexmonster July 19, 2018

Hello Maxime,
Thank you for the screenshots.
Running totals are reset if there is a nesting (in your case, Month is nested under Year).
As a workaround, you can use date string date type to combine year and month in one hierarchy.
Please check the following sample:
Hope it helps.

Please login or Register to Submit Answer