Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have month with year, sales. I want rolling 3 months sum. If I click only Dec 2012, it should show the previous 3 months rolling sum. I tried this expression, it doesn't work according to my requirement "sum( aggr( rangesum( above( sum(Sales),0,12) ),Month))". Can anybody help?
Do you have any Month Number column in your data model then it would be easy,
In Your expression expression your are using 12 months rolling but you want it for selections right?
Is your requirement only for selections or without selections also, if possible give other month columns
Without selection
In your script,
Create :
,AutoNumber(Num(Month(YourDateField, '00')&'/'&Year(YourDateField, '%Year month SEQ') as [%Year month SEQ]
Than, as an expression :
sum({<YourDateField=,Month=, Year=,[%Year month SEQ]= {">$(=max([%Year month SEQ]) - 4) <=$(=[%Year month SEQ])"}>}sales)
result if I select Fev 2017 :
Can anybody tell the solution for Rolling Month?
Best way to do this would be to use The As-Of Table