Thanks fro your reply.
My requirement is bit different here.
I have a dashboard which has 3 different sheets.
1. Sheet 1 - has filter named Hospital
2. Sheet 2 - if user selects a hospital, then Sheet 2 will give a list of all the branches of that hospital. If filter is set to 'ALL' this sheet would not appear
3. Sheet 3 - will display the number of patients for each selected branch in Sheet2, Otherwise should be blank.
I need to implement below functionality.
Initially user should only see Sheet 1. When the user will make any selection in filter called 'Hospital' in Sheet1 then sheet 2 should appear. if the filter value is 'ALL' then sheet 2 should not be displayed.
Then user will make any selection in Sheet2, then Sheet3 should appear.