This content has been marked as final. Show 3 replies
You could use the MDShift to reference past values.
So, in your example:
FIX(&CurrYear/*+ Rest of dimensions*/)
IF(ISMBR(JAN:&CurrMonth)) /*Current Month is the month that you want to calculate the moving average for */
@MOVAVG(/*logic for moving average goes here*/);
@MDSHIFT("AC_XYZ",-1,Period /*Period is the dimension that has months so if yours is a different name, replace with that dimension*/),);