4 Replies Latest reply: Mar 10, 2017 5:43 AM by Muñoz Héctor RSS

    Name of the best SalesMan

    Muñoz Héctor

      Hi guys,


      I need to put the name of the best Salesman (the one who sales the greatest amount) in a text box. I have used the following expression:


      =FirstSortedValue(Salesman, Aggr(Sum([Total Sales]), Salesman), Count(DISTINCT Salesman))


      It works but is not as smart as I would like. For example, I have to put a third parameter: Count(DISTINCT Salesman), to get the last position in the list of salesmen by sales as it is ordered in ascending order...


      Sure that a better way exists... Any idea???


      Come on, it is friday... ;-)


      Regards,

      H