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. 

       

      Aggr(

      Rank(

      $(QTD_Sales),

      ),

      [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.


      Thanks!