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.
LinkedIn
Twitter
