Percentile distribution of customers on total sales amount and shared over a bar chart

[Architect]

'top X% of customers are responsible for Y% of total sales' - how we create one line chart and derive such output?

Let me provide some dummy data -

Tran ID	Cust ID	Sales
260931145	AA	5840
315033323	CC	5029
275618319	BB	2396
330493554	AA	5240
140614679	CC	5467
282028508	AA	4480
297152365	CC	2458
285995215	AA	1255
162141627	DD	4421
170163026	AA	401
186137589	DD	1678
243420751	BB	3368
137864261	AA	5722
306808185	DD	3058
213971526	BB	3214
147063316	DD	3703
284114268	EE	2146
139492351	BB	6394
277633751	AA	5799

from this data we are to create a Bar  chart  that can give us below information-

top X% of customers are responsible for Y% of total sales.

Please note top X% Customers will be calculated on 'Sum of Transaction Amount'.

top 10% customer by sales amount is responsible for 60%total sales and bottom 30% customers make only 5% of total sale amount,

Please note we can only use "Data Manager".

@MatheusC 

@Anbu 

@Louveduval 

@Sebastian_Dec 

@JoelStransky 

[Architect]

Let me provide some dummy data -

Tran ID	Cust ID	Sales
260931145	AA	5840
315033323	CC	5029
275618319	BB	2396
330493554	AA	5240
140614679	CC	5467
282028508	AA	4480
297152365	CC	2458
285995215	AA	1255
162141627	DD	4421
170163026	AA	401
186137589	DD	1678
243420751	BB	3368
137864261	AA	5722
306808185	DD	3058
213971526	BB	3214
147063316	DD	3703
284114268	EE	2146
139492351	BB	6394
277633751	AA	5799

from this data we are to create a Bar  chart  that can give us below information-

top X% of customers are responsible for Y% of total sales.

Please note top X% Customers will be calculated on 'Sum of Transaction Amount'.

top 10% customer by sales amount is responsible for 60%total sales and bottom 30% customers make only 5% of total sale amount,

Please note we can only use "Data Manager".

@MatheusC 

@Anbu 

@Louveduval 

@Sebastian_Dec 

@JoelStransky 

[Architect]

@sunny_talwar  can you please have a look.