I've built 5 different sheets but want to display only 4 of them at a time on my dashboard. 3 of them will remain static but the 4th one I want to rotate between the remaining 2 sheets. I'd like to make it dynamic depending on which filter is used. So for example one of the sheets shows expenses by city and the other shows expenses by state. If I use one filter, I want it to dispaly the sheet that has state expenses and if I use the other filter, I want to display the sheet that has the city expenses. Is there a way to do that?
Robert,
It is definitely possible. Here is an article that shows some options along these lines: http://vizpainter.com/sheet-selection-on-steroids/
Also, here is a workbook in the Workbook & Calculation Library: Sheet Selection on Steroids
Regards,
Joshua
