Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Find the biggest amount

abardaje
8 - Asteroid

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!

4 REPLIES 4
binuacs
21 - Polaris

@abardaje One way of doing this

 

binuacs_0-1657036458659.png

 

IraWatt
17 - Castor
17 - Castor

Hey @abardaje,

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

IraWatt_0-1657036556024.png

Any questions or issues please ask :)
HTH!
Ira

FreeRangeDingo
ACE Emeritus
ACE Emeritus

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

FreeRangeDingo_0-1657036704241.png

 

abardaje
8 - Asteroid

Thank you all :) 

Labels
Top Solution Authors