Get the top salesman in a textbox

[Anonymous]

Hi,

How do I get the top salesman in a textbox just the name.

Salesman  Sales

A                 1000

B                  2223

C                  2311

A                 3234

So I want to sum the sales and show me the highest Salesman in a textbox, so 'A'.

For now, I've stripped a chart and showing largest value in a chart, it works, but I'm sure I've done it in a textbox before.#

Thanks guys

[sunny_talwar · Accepted solution]

Try like this:

FirstSortedValue(Salesman, -Aggr(Sum(Sales), Salesman))

[Anonymous]

Thanks Sunny

[sunny_talwar]

Always glad to help

[Anonymous]