Hi Community,
I have to show rolling to Q9 and actuals(Total), I have expression for Rolling but I need to show Total with actuals like attached.
Rolling I have expression like this
1.sum({<BS_TYPE={'ASS'},%Month = ,%Year = ,YearQuarterID = {">$(=max(CurrentYearQuarterID)-3) <=$(=max(CurrentYearQuarterID))"} >}RWA)
2. sum({<BS_TYPE={'OFB'},%Month = ,%Year = ,YearQuarterID = {">$(=max(CurrentYearQuarterID)-9) <=$(=max(CurrentYearQuarterID))"}>}RWA)
etc..,
now how to show actuals with rolling
