top 3 salesmen in textbox

[#1]

hello everyone,

suppose there is a table having the sales done by salesmen and names of the salesmen.if i have to show the list of top 3 salesmen based on sales done in a text box,how can i show this?

thanking you,

kunal bhattacharjee

[anbu1984 · Accepted solution]

Check this app

[amit_saini]

Kunal ,

Try this  as expression:

=aggr(if(Rank(sum(Sales))<=3,Sales),Sales) (For calculating Top 3)

Thanks,
AS

[SergeyMak]

Hi,

Why do you need to see them in textbox? Why can't you use a straight table and use format to get rid of all the lines?

With textbox you can try to look at Rank() and Concat() functions

Regards,

Sergey

[amit_saini]

For top 3 salesmasn:

=aggr(if(Rank(sum(Sales))<=3,Salesman),Salesman)

Thanks,
AS

[jagan]

Hi Kunal,

Check this expression

=Concat(If(Aggr(Rank(Sales), Salesman) <=3, Salesman), ',')

Note : Replace Sales and Salesman with you actual fields, it will give you the Top 3 Salesman names as comma separated.

Hope this helps you.

Regards,

Jagan.

[PradeepReddy]

try something like this...

=concat(distinct IF(aggr(rank(sum(Sales)),Salesperson)<=3,Salesperson&CHR(13)))

[#8]

hey amit,

your expression is not working.

cheers,

kunal bhattacharjee