Summarize value based on highest value

Question

Dear Alteryx Enthousiasts,

I am new to Alteryx and I have the following question:

I would like to summarize my input based on project code and thereafter, only select highest value (amount) per projectcode. when using the summarize tool I can't add product type to the output without grouping by this field/column.

See my Input and desired output below.

I hope somebody with experience can help me.

Kind regards,

Jaap

mbarone · Accepted Answer

You'd want to do two summarize tools, then join them.  The first one would be what you show for your Input.  Your second would be grouping simply by Proj Code, and taking the Max amount.  Then join back (on Project Code = Project Code, and Amount = Max Amount) to the first one.  That should do it.

messi007 · Accepted Answer

@jaapkluck,

Please see below:

Attached the workflow, hope that helps!

Regards,

messi007 · Accepted Answer

@jaapkluck,

Please see below:

Attached the workflow,

If this solves your issue please mark the answer as correct, it will help others!

Regards,

jaapkluck · Accepted Answer

Thanks for the help.

What I have also learned in the last 30 minutes is that in order to create a successfull MAX summarize I should make sure to have the correct format type of column Amount.