I need to create a concentration histogram chart, which tells, by each supplier cluster, the percentage of the total number of product it has.
I have available the following table:
Supplier
# Products
A
200
B
150
C
105
D
100
E
90
F
80
G
70
I need to then cluster the suppliers due to its number of products. I mean: the first 1% suppliers (lets say only one in a total of 100 suppliers) is categorized as 'first 1%', the following falls in the 'from 1 to 20%' cluster and so on.