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 Chu
Pipedrive, Inc.
Manager of Planning & Analysis
------------------------------
Choy Chu
Planning Manager
Pipedrive
------------------------------
Original Message:
Sent: 01-10-2023 16:06
From: Irene Tang
Subject: "Multiple Choose Function" #Give and Get Help"
Hi Shoeb!
Thanks for the question, I'm sure other community members might have the same or similar question!
After some digging around internally, hopefully this gives you some help:
You can have users select 2 different scenarios in the choose option by creating 2 dummy sections so that they can each choose a scenario. Then in the main section (the section that actually brings back data, you can reference the selection of the 2 dummy sections as form variables.
Would love to hear from other community members if you have any other thoughts or insights! Or if not, is this multiple choose function something you'd implement in your own organization?
Tagging some awesome community members to pick their brains 🧠 @Brendan Eger @Josh Weinberg @Benjamin Cleaver @Choy Chu
Thank you! 😊
------------------------------
Irene Tang
Community Marketing Manager
Vena Solutions
Original Message:
Sent: 01-10-2023 05:22
From: Shoeb Salam
Subject: "Multiple Choose Function" #Give and Get Help"
Hi
I would be grateful if someone has any suggestions.
I am trying to create a template with the hope to have two choose options for the user. For example letting the user choose "Actual" for scenario one and then Annual Budget in the second choose. But if they wanted to let them choose any scenario for example letting the user choose two reforecast scenarios side by side.
I have already mapped the scenario blocks with form variable but now trying to figure out how to do the choose mapping to the dialogue box on opening lets them their desired scenarios.
Many thanks in advance for any help and suggestions. :)
------------------------------
Shoeb S
PPG
------------------------------