Find the biggest amount

[abardaje]

Hello, 

Can someone please help me on how to get the biggest amount from my attached sample. 

 Attached is for the sample : Input tab is the sample data while the output tab is the result I want. 

Thank you!

[binuacs]

@abardaje One way of doing this

[IraWatt]

Hey @abardaje,

You can just use a summarize and a join tool like this:

Any questions or issues please ask :)
HTH!
Ira

[FreeRangeDingo]

You can use the Summarize tool as I have shown here and then filter out the Jewelry after that.

[abardaje]

Thank you all :)