Good morning Alexander
I'm a little confused by your example becxause I could not find the cases you referenced but that said I think you want to Identify thos cases where all the participants are from the same team
First on a case by case basis I determined the Min and Max "Team" since is is a alpha continuum Team A and Team B are distinct in the sense if both are present Min will not = Max
Then I put in a filter
It will return this based on the chart in your file
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.
HelpExample.twbx 47.3 KB
Thank you for the quick response! This is exactly what I was looking for. As for the part that you were missing...The 6-digit numbers in [Case ID] are the cases that I was referring to. I removed all the other columns to reduce confusion.
Glad to help out -