Hi, i want to ask what is the best approach to create a YTD calculation from my cube? I already have the Cube but it still calculates per monthly.
Hi Alfen, you can calculate year to date using the inbuilt time function Yearly Cumulated Value under your block settings - that will cumulate over a single year and then reset at the start of each year. If you want to cumulate over multiple years without it resetting you can use the Cycle setting to override the normal 12 month cycle.
