Running totals reset

Hi,
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,
Maxime
 

1 answer

Public
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: http://jsfiddle.net/flexmonster/p4ey378r/
 
Hope it helps.
 
Regards,
Ian

Please login or Register to Submit Answer