Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi i am curently battling with a rolling 12 expression.
(
i have a derived value in the form of an expression ='omsättning'. i wish to have 12 months aggregated value (sum) in a single column.
attempt 1&2 without luck are below , any suggestions?
Sum({<MonthYear ={">=$(=Date(addmonths(Max(MonthYear), -1), 'YYYY-MM')) <=$(=Date(addmonths(Max(MonthYear), -1),'YYYY-MM'))"} >} Omsättning)
SUM({1<MonthYear={">=$(=addmonths(monthend(max(MonthYear))+1,-12)) <=$(=max(MonthYear))"}>}Omsättning)
hi,
Please find attached.
HTH
sushil