Creating a ranking

[Anonymous]

I'm having trouble creating a ranking system. I want to be able to rank each ID by the percentage of users reaching the last stage in the registration process. Basically, I want to be able to rank the last two columns (indiviudally but honestly a formula for 1 is sufficient) by highest percentage, by ID in the first column. 

BTW they are calculated fields.

[v-piga-msft]

Hi @Anonymous ,

More details will be much helpful.

If it is convenient, could you share some data sample which could reproduce your issue so that I could have a test on it?

In addition, you'd better share your desired output based on your sample data so that I could understand your logic better.

Best Regards,

Cherry

[Anonymous]

Basically, I want to rank the top 5 sub IDs and bottom 5 sub IDs each day. So I need a functional formula to rank these IDs on a date breakdown.

I wank to rank based off of % Reg -> Fulfillment column percentages. The higher the percentage, the lower the rank