5 Replies Latest reply on Jul 5, 2018 7:57 AM by onur.kocyigit

    Change worksheets dynamically by two filter

    onur.kocyigit

      Dear all,

       

      I have two worksheets on my dashboard. As you can see I also have 2 filters (Country and Region). I want to achieve that my dashboard is only showing me the worksheet which has been actually filtered.

      Means if "Country" is filtered it should only show me worksheet 1 and set filter "Region" to "All". And if "Region" is filtered , it should show me worksheet 2 and set Filter "Country" to "All". In case there is no active filter it should show me worksheet 1 as default worksheet. Attached you´ll find an example workbook.

       

      Thank you in advance!

       

      Nachricht geändert durch Onur Kocyigit