Not certain I fully understand what you are doing but see the attached
is this what you expect to see?
I did changed the join from Name to Color
then on the summary sheet
Is this what you wanted?
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Drilldown Example_v10.2.twbx 70.8 KB
Thanks for your help! I'm actually just looking for the same thing as my Screen 2 screenshot just without Aidan being included in Sheet 2. Do you have any ideas how that could be done?