Hi Shoeb & Irene,
I was actually thinking about this same question earlier this week when I was refreshing our reports.
Currently, we have choose box for selecting the scenario for forecasted months. Usually the actual scenario is used for actual months. However, our actuals change every time data is loaded bc we tend to have different versions of actuals over time, lol.
I was thinking to change the scenario for historicals to be part of the choose box to pull the specific version of historicals (assuming you have the different historicals saved/versioned).
Our forecasted months scenario is a formula, so historical months scenario need to be formula too.
In the 'arbituary page settings' (not sure what that box is called, but it is the upper left corner of the spreadsheet where you start mapping the spreadsheets settings), you can have 2 lines for scenario, one for historical months and one for forecast months. You will have to set the page mapping to these, and assign different 'sections' in the page mapping dialog popup box. Columns where you have the scenario mapped, you will reference to these scenario lines depending whether historical or forecast. I think what I am writing is essentially the same as what Irene wrote, lol. I tested this and seem to be doing what I want it to do....I think, lol.
Hope this helps you.
Regards,Choy ChuPipedrive, Inc.Manager of Planning & Analysis
Forum brought to you by Vena Solutions Inc.