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.
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()
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |