Skip to Content

Including Query with Different selections in a Workbook

Business Requirement:

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.

Issue:

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

  1. Go to Workbook Settings à Variable tab. Uncheck “Display Duplicate Variables Only Once”
  2. Go to Workbook Settings à General tab. Check “Refresh Workbook on Open”
  3. Save the Workbook.
  4. Open the Workbook. You will get 2 variable screens in 1 dialog box, 1 for each of the 2 sheets maintained in the workbook.

Settings1.png

Settings2.png

Output:

Settings3.png

Settings4.png

1 Comment
You must be Logged on to comment or reply to a post.