I feel like this should work but for whatever reason it does not. I have the below data and I am trying to return for each ID the Location which has the Max Point values. If tied, return all rows where the max is tied. Using Summarize however doesn't seem to work.
Any idea how to do this?
ID | Location | Points |
Case_123 | Australia | 1 |
Case_123 | Canada | 4 |
Case_123 | Macau | 1 |
Case_123 | Mexico | 4 |
Case_123 | Singapore | 1 |
Case_123 | Thailand | 1 |
Case_123 | USA | 4 |
Case_123 | United Kingdom | 7 |
Case_456 | Australia | 5 |
Case_456 | Canada | 5 |
Case_456 | Thailand | 3 |
Case_789 | Mexico | 1 |
Solved! Go to Solution.
Hi @hike44
Here's how you can do it.
In the Summarize Tool, you want to only group by the ID and then find the Max Points. Then Join the back to the original data by ID and Points to get all the locations that match.
Cheers!
Phil