Rank question

[Sammy22]

Hello

i have a table like the below. I want a rank column which will show me the rank based on the price. how can i do this?

Order No	Product	Price	Rank (Price)
123	Bread	3	1
123	Eggs	2	3
123	Eggs	2.5	2
123	Beans	1	4

[Jean-Balteryx]

Hi @Sammy22 ,

You can do it by using Sort tool then RecordID tool ! Here is a sample workflow !

[atcodedog05]

Hi @Sammy22 

You can do something like below. This method will help you if you want to maintain data row order.

Workflow:

1. Using record id tool to capture order.

2. Using sort tool to sort descending on price.

3. Using record id to set rank.

4. Using sort tool to sort back into order.

Hope this helps : )

[Sammy22]

There are multiple order numbers so i need the ranking grouped by the order number. Sorry should have clarified in the first message!

[Jean-Balteryx]

Here is the updated version !

[atcodedog05]

Hi @Sammy22 

You can use multi-row formula tool to create group ranking.

Workflow:

Hope this helps : )

[Sammy22]

Can it give the same rank if the price is the same. it wouldn't currently do that it seems.

Order No	Product	Price	Rank
123	Bread	3	1
123	Eggs	2	2
123	Eggs	2	2
123	Beans	1	4
456	Eggs	3	1
456	Eggs	2	2
456	Beans	1	3

[atcodedog05]

Hi @Sammy22 

It should work. Refer snapshot below.

Hope this helps : )

[Jean-Balteryx · Accepted solution]

Yes it can ! Here is the updated workflow !

[atcodedog05]

Nicely done @Jean-Balteryx 

I guess i forgot same ranks my bad😅

Cheers and Happy Analyzing 🙂