Question: Final Bookings Forecast
SummaryQuestion: Final Bookings Forecast
We have an requirement to Sum up the values of 'Final Bookings Forecast' for past 12 months and also to sum up the values of 'Final Bookings History' for past 12 months and do some calculation.
We are able to sum the values of 'Final Bookings History' for past 12 months as this measure stores the Historical values.
How do we sum up the forecasted (Final Bookings Forecast) values of past 12 months? Since there are no values being stored in this measure when we move forward to next months?
Can anyone please suggest the approach to achieve this? This is critical requirement in our project.