Top 20% of customers for a sales manager in Picot table

[Levoe]

Hi All,

I try to fix following problem. I want to see in a pivot table (or if not possible in pivot in a normal table) per sales manager the top 20% of the customers measured via sales.

I only found out how to see the top 20 customers per manager but not the top 20% of the customers. For example if a manganese has 100 customers I want to the the best 20 but if he only has 10 customers I only want to see the best 2. So  the top 20% for each sales manager. I entered a demo below.

Do you have any idea how to fix it in the front end cause I only have designing rights.

 

Thanks already

[male_carrasco · Accepted solution]

Hi @Levoe 

You can try: Sum( {< Customer= {"=Rank(sum( Sales),4)<= 20"}>} Sales)

Best Regards