Using Summarize tool to find Max (two fields)

[hike44]

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

[Maskell_Rascal · Accepted 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

[Tyro_abc]

Hi @hike44 

Try this

Best Regards

abc