Dear visitor, despite all the challenges, our team continues operating at full speed.

We are ready to help with any questions you may have. Please fill out this quick form and we'll get back to you.

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