Top 10 Table

[#1]

Hi Folks

I hope you can offer some guidance,

I have data that identifies different activities and which user did what ,

User	Task	Number
Anne	Selling	10
John	Buying	15
Fred	Logging	5
John	Selling	5
Fred	Buying	10
Trevor	Logging	16

I am looking to build a Top 10 preformer per task - so looks something like

User	Task	User Total	Total	% for user
Anne	Selling	10	15	66.67%
John	Buying	15	25	60.00%
Trevor	Logging	16	21	76.19%

Can anyone give me guidance ? Or if they have an example it would be really appreciated

Thanks

A

[anbu1984]

Check this app

[#3]

Hi Anbu

Thanks for the attached  -

I had actually managed it that far to have top 10 overall ,  my issue is trying to get the top person per task - do you think I should just put in a set for each task ?

Thanks

A

[#4]

Don't see how to do it within 1 table. I would make some text fields and create the top 10 in there with the use of set expressions. But that would not be easy for export.

[#5]

Salesman	Product ID	Sales	Overall %	Total sales
Charles Ingvar Jönsson	1000	17678	56%	31766
Charles Ingvar Jönsson	2000	28330	45%	63545
Olivier Simenon	3000	56789	54%	104215
Bill Yang	4000	112220	49%	230087
Lucky Luke	5000	127432	41%	313649

So the Bottom Left chart would look like above

Thanks

A

[#6]

Thanks Coen,

maybe thats the way forward using Text box

Thanks

A

[anbu1984 · Accepted solution]

Check this updated app with top 5 in each country

[#8]

Thanks Anbu

This looks like the solution for me

Appreciate it

A