Business want to include two queries in a workbook. The query is same but the variable selection is different from each other. These should be displayed in two different tabs of a workbook.
Now when I change the Sales Org in First Tab to “X” then it also changes to the Second Tab. And that is something Business doesn’t want.
Settings to be maintained
- Go to Workbook Settings à Variable tab. Uncheck “Display Duplicate Variables Only Once”
- Go to Workbook Settings à General tab. Check “Refresh Workbook on Open”
- Save the Workbook.
- Open the Workbook. You will get 2 variable screens in 1 dialog box, 1 for each of the 2 sheets maintained in the workbook.