Sumrange for all periods/years in cube
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!
Tagged:
0