The sheet swapping did not work for me either. But I would just change the calculation Dept/Cat Filter to
Case [Dept/Cat Select]
When "Category" then [Customer Segment]
I shall put this in one visualization lets say color, labels etc. You do not need sheet swapping with my technique. You will be able to change the view using one view and there is no need to create two sheets and dashboard.
1 of 1 people found this helpful
Give this a try:
Create a calculated field that's just a placeholder that just contains a 1 or " " or something, and make sure to make it a dimension (and discrete).
And then on each of your sheets, place it on the Columns shelf, and de-select the show header item.:
Then, on your dashboard, make sure that for each of the frames the "Fixed Height" is de-selected. Then it should work.
Hope that's helpful. Please let us know if that addressed your goal.
Wow that works like a charm! Thanks Kaz for the quick response.
I can never come up with this magic of calculation field :-) Thanks again!
Sharad, I am using the superstore data just to show the functionality I need and my data is different so I have to do swapping. Thanks for your input.