Forecast archive

3.47K viewsTips and Techniques


My model creates multiple forecasts. I would like to archive these forecasts every month in order to show my current forecast and previous forecasts on the same charts.

I’m trying to think through the simplest way to do it. One option is to export my forecasts, and then re-import. This has the disadvantage of managing export / import files.

A second option is to have a different model file for every time period that I forecast, and then use intermodel formulae.

Ideally, I would like to pick my archived forecasts to show along with my current forecast.

Any thoughts / advice welcome!



Create Dimensions (Categories) for Year, Month, Forecast and Line Items.

Latest Questions