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
51
Views
9
Comments

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:

@SUMRANGE("PER","Jan":@CURRMBR("Period"));

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

@SUMRANGE("PER",@XRANGE("FY20"->"Jan",@CURRMBR("Year")->@CURRMBR("Period")));

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

Any help?

Thanks!

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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