YTD Calculation problem

andreaLin....

Hi All,

I’m trying to figure out an easy way to do the YTD calculation.

For example, if I have a cube where each month in 2019 has the same value (10 euros) and in 2020 has the same value (20 euros).

i want to show on dataview the YTD data as following:

Jan 19 (10 euro)

Feb 19 (20 euro)

.. and so on

Dec 19 (120 euro)

Jan 20 (20 euro)

…

Dec 20 (240 euro)

I used a loop function with Nexel to populate an ytd cube, but I’m hoping to find another way.

Thanks

Bettina Clausen

Hi,

did you try to use the time function "yearly cumulated value"?

Adrien Albrespit

Hi Andrea,

I agree with Bettina, by this simple data flow, you should be able to achieve that:

Results:

Regards,

Adrien