Hi Travis, Thanks. This helped me. But the one difficult situation for me is, I need to map Class 1 to one report/worksheet and Class 2 to another report/worksheet in the dashboard from the same Class 1& Class 2 filter option.
That is the beauty of Parameters Saravana, they are workbook pervasive.
So you can write that same parameter into multiple calculations or even multiple data sources.
For instance, if you wanted to show and hide the worksheets showing class 1 and 2, then you could just write half of that calculation above;
[Class Selection] = 12
([Class] = 'Class1' OR [Class] = 'Class2')
Then putting that on the filter shelf and selecting TRUE, will show Class 1 and 2 when the parameter says so, and hide them when it is FALSE.
Or if you want the sheet that is Class 1 to switch to Class 3, and Class 2 sheet to switch to Class 4, then you can split the calculation up like so;
([Class Selection] = 12
[Class] = 'Class1')
([Class Selection] = 34
[Class] = 'Class3')
It depends on what you want to show on each sheet, but the parameter/calculation combo should be able to handle it!
Thanks a lot buddy