Find the biggest amount

Question

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!

SAMPLE testing.xlsx

abardaje · Answer

Thank you all :)

FreeRangeDingo · Answer

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

IraWatt · Answer

Hey @abardaje,

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

Any questions or issues please ask :)
HTH!
Ira

Workflow.yxmd