Ranking Top Sales Person

[#1]

I would the ability to rank the top Sales Person and show as an Expression in the report. So that the individual Sales Person can see how they rank to the top Sales Person.

Any Help would be greatly appreciated. Qlikview Example attached.

Thanks

[Oleg_Troyansky]

Scott,

in order to rank by an expression (like sum(Sales)), you don't need anything fancy - just use function rank():

rank(sum(Sales))

I'm not sure I understand what were you trying to do with the expressions in your example...

[#3]

I'm trying to rank inside the expression only the top person with ignoring the selections..