Follow along with the sample packaged workbook found in the Attachments section of this article to review the solution.
CLICK TO EXPAND SOLUTION
Buttons for swapping sheets between Sales and Product Details
- Create calculated fields with Strings for buttons. Example: Sales Button : "Sales" and Product Button: "Product"
- Create two placeholder calculated fields as discrete and dimension as following: zero: 0 and One: 1
- On an new sheet named Sales Button drag Sales Button, zero and one to Details on Marks Card
- On an new sheet named Product Button drag Product Button, zero and one to Details on Marks Card
- (Optional) Create the Sales and Product sheets as desired (in our example, these sheets are named Sales by Segment, and ProductDetails)
- Add the Sales Button and Product Button to your dashboard
- Add a Horizontal/Vertical Layout container. Add Sales by Segment, and ProductDetails sheet to this Layout container until a dark blue thick line appears
- Hide the Titles of Sales by Segment, and ProductDetails sheet
- Configure four actions as instructed below. These 4 actions are needed in this example to define both a source and target sheet for each button.
- Action Filter 1 for Sales:
- Select the Sales Button Source Sheet as the Source
- Choose Select to run the action
- Select the ProductDetails sheet as a Target Sheet
- Choose Exclude all values when Clearing the action
- Add a Target Filter using; One as the Source field and Zero as the Target Field
- Action Filter 2 for Sales:
- Select the Sales Button Source Sheet as the Source
- Choose Select to run the action
- Select the Sales by Segment sheet as a Target Sheet
- Choose Leave the filter when Clearing the action
- Add two Target Filters using;
- One as the Source field and Zero as the Target Field
- And Zero as the Source field and One as the Target Field
- Action Filter 1 for Products:
- Select the Product Button Source Sheet as the Source
- Choose Select to run the action
- Select the Sales by Segment sheet as a Target Sheet
- Choose Exclude all values when Clearing the action
- Add a Target Filter using; Zero as the Source field and One as the Target Field
- Action Filter 2 for Products:
- Select the Product Button Source Sheet as the Source
- Choose Select to run the action
- Select the ProductDetails sheet as a Target Sheet
- Choose Leave the filter when Clearing the action
- Add two Target Filters using;
- One as the Source field and Zero as the Target Field
- And Zero as the Source field and One as the Target Field
- Clicking on the button will get the respective sheet in the bottom view
To view the steps showed in the below video, please expand the above section.
Note: the video has no sound.