I need to switch between worksheets in a dashboard. Instead of using a dropdown parameter to toggle between sheets, I need to achieve the functionality by running filtering actions on selecting a sheet( Show/Hide) .
Any help is greatly appreciated!
Showing the detailed report
Hiding the detailed report
Here you can use the sheet selector concept in-order to achieve the above functionality .
Did you try using the action filters .
Please attache the sample workbook .