So, I'm learning enough to see the answer maybe in Action filters.
This thread seems to have the right track, but I can't figure out how to apply it to my data.
The problem I'm having is how to set up my initial table correctly.
How do I create the field that ties it all together?
Do I need to create a pivot field that classifies which data type I'm using, then create a series of If statements that would jump to second sheet correctly filtered?
Here's my latest attempt, but I'm lost in the weeds.
I have summarized calculated fields, and I'd like a click on the bar to link underlying data filtered to that measure value from the raw data.
In other words, I want to see the class performance averaged over various categories, then a click on the category to reveal the individual students that created the composite.
Sample book Two.twbx 207.6 KB