I think you can also replicate the worksheets (each w/ a different filter) and put each on a dashboard.
Thank you for the feedback. I don't think I can recreate using new dashboard/worksheets because the filters are global, and will affect the entire workbook.
I tried playing with the pages shelf, unfortunately, I can't seem to use it from a worksheet to drive the entire workbook. I tried setting the pages shelf in one worksheet (DV - Leases Chart worksheet), then in the dashboard using that worksheet as a global filter, but it's not working.
Any thoughts from here?
Thank you everyone and have a great weekend!
Does anyone have a chance to take a look at this question?
Thank you so much!