This content has been marked as final. Show 4 replies
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... ;-)