Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

Running totals reset

Maxime Flamant asked on July 19, 2018

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