YTD Calculation problem

andreaLin....
andreaLin.... Active Partner
Name Dropper First Comment
in Platform

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

Accepted Answers

  • Bettina Clausen
    Bettina Clausen Employee
    Fourth Anniversary 25 Up Votes 25 Likes 5 Answers
    Answer ✓

    Hi,

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

  • Adrien Albrespit
    Adrien Albrespit Employee
    10 Comments 5 Likes First Answer Level 300: Expanding Board in Your Organization
    Answer ✓

    Hi Andrea,

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

    image.png

    Results:

    image.png

    Regards,

    Adrien

Categories