YTD Calculation problem
andreaLin....
Active Partner
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
0
Accepted Answers
-
Hi,
did you try to use the time function "yearly cumulated value"?
1 -
Hi Andrea,
I agree with Bettina, by this simple data flow, you should be able to achieve that:
Results:
Regards,
Adrien
1
Categories
- All Categories
- 2K Forums
- 1.8K Platform
- 161 Academy
- 328 Resources
- 1 Board Knowledge Base
- 50 Best Practices
- 49 How-To Guides
- 19 Board Advocacy Program
- 194 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- 5 Community Captains
- 1 About Community Captains
- 3 Meet the Community Captains
- 1 Topics & Thought Starters
- Learn from the Board Captains
- Release Notes
- Academy
- 2 Board Academy
- 8 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.2K Idea Exchange
- 338 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP