Top x Percent

[#1]

Hi guys having a bit of a strugle resolving a problem, lets say i have this table:

Company	Revenue
A	200
B	150
C	130
D	110
E	90
F	80
G	60
H	30
I	20
J	10

Now the total is 880 and im after a table that will show me Companies based on 80% of the top Revenues, 80% is 704, so basically my table would show me from company A to company F, that would make 760 thus showing me all the Companies that make at least 80% of the Revenue.

Many Thanks

[#2 · Accepted solution]

Hi

You can add a pareto selection button.

Look at the example.

If you clik on the button, it selects the company which achive 80% of the overall revenue !

JJ

[#3]

Many Thanks exactly what i was looking for.