Rank order based on Select Expression

[JBGreenpaths]

Hello,

I'm trying to assign a rank to each row within a specific group. I have a list of stores in a ranked order but the stores fall within different territories owned by different users. I'd like to give them an overall rank as well as rank within their territory. 

For example:
User A has 3 Stores that have an overall rank of 5, 20, and 25 but that same list of stores would be ranked 1, 2, and 3 in their territory. 

I'm not even sure where to start, I can order a list by the rankings per user but I can't figure out how to assign it the value.

[Suvrutt_Gurjar]

In general, you could make use of INDEXOF() expression tip.

INDEXOF() - Google Cloud Community

If you would still wish to have some more help, please post the relevant column details and how the users select their own territory ( by slice or some other way) so that we could see if and how we can use INDEXOF()