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
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
Thank you. This is what am looking for.
Also can we add "Ranks" in ascending order basis margin$ in column F6?