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
⋅ 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
