-
1. Re: Filtering Records with Two Primary Keys
Jim DehnerOct 12, 2017 7:35 AM (in response to Alexander Schraut)
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
Jim
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
-
-
2. Re: Filtering Records with Two Primary Keys
Alexander Schraut Oct 12, 2017 7:56 AM (in response to Jim Dehner)Jim,
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.
Thanks again!
-
3. Re: Filtering Records with Two Primary Keys
Jim DehnerOct 12, 2017 7:56 AM (in response to Alexander Schraut)
Glad to help out -
Thanks
Jim