This content has been marked as final. Show 2 replies
Hi, I have a Rank table that ranks sales territories based on sales. The below expression works great if no selections are made.
However, if a selection is made, say a specific rep is selected, their rank becomes 1. For example. TM Boston is 17 overall with no selections made.
but if I select TM Boston, then their rank changes to 1
I need it to stay 17.
I need the ranking to consider all of the reps regardless of which rep is selected so we can look at specific rep information and their overall rank.