Optimization logic using Alteryx

[rrakeshn]

Hi All,

I am trying to work on an optimization logic for details as in the attached file. Following are the tasks am planning to execute using Alteryx:

1. Rank Margin$ in ascending order. For instance, margin 248 being highest will be ranked No.1 & margin 0 ranked the lowest

2. Sort “Nameplate” & “Market” combination basis Ranking done in step no.1. For instance, ABC1 & South Korea with 248 margin will be at the top & TUV & India with 0 margin will be at the bottom of the table

Could you please suggest a way forward in Alteryx to arrive at this logic & output.

Thanks

Rakesh

[gabrielvilella]

Hi @rrakeshn, is this what you are looking for? 

[binuacs]

@rrakeshn something like this

[rrakeshn]

Thank you Gabriel 

Yes am looking for a similar output. However, the primary criteria for sorting should be Margin$ first. Also we need to add another column showing "Ranks" in ascending order basis margin$.

Regards,

Rakesh

[rrakeshn]

Thank you. This is what am looking for.

Also can we add "Ranks" in ascending order basis margin$ in column F6?

[binuacs]

@rrakeshn Updated the workflow by adding the Rank column