3 Replies Latest reply on Jun 21, 2018 2:33 PM by Deepak Rai

    When user selects a site show region on dashboard

    Brian Adams



      I'm sure this is really simple but I must be simpler. What I want is to show the associated region when the user selects a site from a drop-down.


      In a sheet title I have


      Region: <Region> | Site: <Site Name>


      When I select a state from the State filter the name of the state shows up in the title but region does not change. How can I get region to change based on state selection?


      I tried attaching a workbook that used the Superstore data but it said the workbook was too large. Does anyone know how to pare down the dataset?