Help Needed with Ranking Function

[hash_89]

Hi All,

I have a data that when using Ranking Function in Excel gives the following result:

This was the formula that was used for the column:

How can i get this automated in alteryx?

Thanks!

[IraWatt · Accepted solution]

Hey @hash_89,

This is how I would achieve that:

Any questions on how it works please ask.

HTH,

Ira

[hash_89]

Thankyou!

[IraWatt]

No worries @hash_89, glad it helped!