I'm looking for a way to rank accounts based on a number field value, and then re-rank again within each user's territory. So holistically one account might be ranked number 543, but in my territor this account is ranked #1. I'm looking at using the territory field object to accomplish this. What would be the best way to re-rank accounts if someone is removed from the territory? I think a trigger is the best way, but I was wondering if anyone else has accomplished something similar maybe using Metric Configurations? Thank you!
Rank Accounts within Territory