Last 12 months SUM and Actual Version
I am trying to workout a formula for Forecast Version Line Item. The requirement will be as given below.
Source Module: Source Line Item - Sum of "Sales" of last 12 months in Actual Version
Target Module: Target Line Item- "Sales" for 1 period in Forecast Version.
Eg. Assuming I am forecasting Sales in Feb 2021; So the result should be = Sum of Actual Sales from Feb 2020 till Jan 2021.
It is needed to get some ratio calculated for further calculations in Forecast version itself.
Any help will be appreciated.