2 Replies Latest reply: Feb 8, 2018 1:45 PM by Digvijay Singh RSS

    Need Rank to always Rank on all Data regardless of selections

    Dan Coen

      Hi, I have a Rank table that ranks sales territories based on sales. The below expression works great if no selections are made. 






      [Territory Rep])

      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.

      2-8-2018 1-32-37 PM.jpg

      but if I select TM Boston, then their rank changes to 1


      2-8-2018 1-37-45 PM.jpg

      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.