1 of 1 people found this helpful
I was able to get it working, Tim! I did it by creating a series of actions. Each action filtered the following sheets, and the trick was to use a Selected Field of whichever Level the action was for. The list sheet updates according to all of the selections you've made. Here's what the filters looked like:
Thanks Vincent, this doesn't quite get it.
It still doesn't filter the graphs above if I click on one below, what I'm interested in full functionality each way. I should also note, the table is for demonstration purposes only.
I have semi stumbled into a solution, by making it a duel axis, and the level's as attributes to each field in one, but not both of the values. This removes the ability to click on the bars to filter, (but I can on the names) but it does give me the filter functionality I need.
If you can figure out a way to make it work based on bars, please let me know.
Again appreciate your help, and apologize for being unclear in my question.