Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Check this app
Check this app
Kunal ,
Try this as expression:
=aggr(if(Rank(sum(Sales))<=3,Sales),Sales) (For calculating Top 3)
Thanks,
AS
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
For top 3 salesmasn:
=aggr(if(Rank(sum(Sales))<=3,Salesman),Salesman)
Thanks,
AS
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.
try something like this...
=concat(distinct IF(aggr(rank(sum(Sales)),Salesperson)<=3,Salesperson&CHR(13)))
hey amit,
your expression is not working.
cheers,
kunal bhattacharjee