Hello,
I have a measure that calculates the days passed since a salesman made his last sale.
I would like to create a ranked bar graph that shows the top/bottom salesmen based on my measure
My hierarchy is branch ->salesman (so if i drill down in a branch, I see the salespeople working there).
I would like my ranking to to find the "worst" salesmen but only from the "worst" branches.
So this is kind of a double/embeded ranking.
Finally, is there a way to add a tiebreaker in the ranking? Because if I have 20 salesmen with the same "days since last sale" then I see them all in the ranked graph. Is there a way to determine which ones I will see instead of all of them with the same "score"?
This is why I thought of the "worst" salesmen but only from the "worst" branches "solution". So it would kind of act as a filter/tiebreaker.
Is there a better way to do something like this?
Thank you.
