Rolling 3 month sum
We have dimensions, Years, Periods (time dimension) with Quarter - Month, Account, etc. I would like to create rolling 3 month sum, for example, currently it is Oct, rolling three month sum would be Aug+Sep+Oct, so I create member RollSum under Period, then I am trying to use MovSum in the following formula as test
@MOVSUM ("Net Income",3, "Jan":"Jun");
However it comes back without any value when I retrieve from SmartView, any pointer and advice on where I did wrong? or is there better way to do this?