- Click on your Dashboard drop-down menu and select 'Actions...'
- Click 'Add Action' and choose 'Filter'
- Under Source Sheets, deselect everything but SCORE
- Set 'Run action on' to 'Select'
- Under Target Sheets deselect everything but PANEL
- Set 'Clearing the selection will' to 'Show all values'
Hope this helps!
Thank you for your reply; I had tried that and it didn't work as I was trying to filter on a filter (if one option in the dimension i was using was the chosen filter, show me this list. If another option is the chosen filter, show me that list), and that doesn't work. I restructured my data into two sources and worked it out that way.