How to calculate forecast percent based on latest 3 months (average) actuals?




Current setup:

I have a source module where I will get actuals percents every month. The module doesn't include the version dimension/list. 


Target module:

I want a module that includes version actual, forecast, and probably later other versions as well. I would like to get from the source module the actual (allocation % = line item). For the forecast version, I would like to calculate rolling forecast % which will be based on the latest 3 months average.


The picture attaches will illustrate my need for concrete.


Thanks in advance,


Best Answer