You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Sumrange for all periods/years in cube

Received Response

Hello, experts,

I need a dynamic calc than summarize all data from the beginning of years.

I have a Year dimension and a Period dimension, and also a DataType dimension (PERIODIC/YTD)

YTD is dynamic calc and I need to summarize all data across the years like this example:

Grey colour, Normal YTD:


Blue colour, My requeriment: I try this formula but doesnt work:


My first year/period in my application is FY20->Jan

Any help?


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!