Rank funcion

[Deepak1990]

Hi Team,

I have list of sales rep who is sorted rank wise. I need the list sales rep who has move up in rank, but i when filter the rank difference columns(Rank Yesterday - Rank Today) its showing the list of Sales rep, but the rank is changing as per the new list. Is there any way i can get the default rank in the table.

Regards

Deepak

[Anonymous]

Hi @Deepak1990 ，

If it's convenient, please provide us with Sample data with privacy information removed and expected results.

Thank you!

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.