Running Forecast in narrative reporting
How can I create a simple table to show running forecast?
Lets assume, we are in Oct 2022. Our Fiscal months are Jan -Dec. We have actuals from Jan - Sept. I want to show Forecast scenario (data) from Oct - Dec. We have separate scenario for Actuals, and Forecast.
If I have rows to show actuals, I see actuals from Jan - Sept. But nothing for Oct - dec. If I select Forecast as POV, then I see data from Oct - Dec. Unfortunely, our forecast data doesn't become actuals data after month end. It only happens at quarter end.