Hi Clayton. Are you able to accomplish this through a couple of Dashboard Actions?
Your primary worksheet would show everybody...
...your secondary worksheet would show your averages (by Shift by Tier).
You Dashboard Action would filter worksheet #2 by Shift and Tier when any employee in worksheet #1 is clicked.
A second Dashboard Action operates on worksheet #1, limiting it only to the Name, Shift, and Tier. In this way, a click limits the list to just those employees who share that Name, Shift & Tier (Clayton, Brunch, L1). Clicking a second time would display all values.
Let me know what you think or if you would like me to attach a little .twbx sample. Good luck!