Hello,
I am trying to do a simple ranking based on sales growth, but divided into two different classes of territories (big and small). Basically I want 1-20 (or whatever the highest is) in my large territories, and then to start back at 1 for my small territories. The sales growth metric is calculated in an expression. I'm trying to basically use the expression Rank(Sales_Growth) to accomplish this, but it is ranking only within each of my regions (and then when a new region begins in the chart, the rank starts back at 1). How do I designate that I only want to rank within the class, and ignore region???
I've attached an Excel document showing what I'm trying to do. The "Sales Chg" field is an expression. I can't figure out why the ranking is happening within the Regions....there's nothing in my document that says to sort by this!
Thanks!
Kristin
