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

[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 

[G3S · Accepted solution]

advance apologies, I am not familiar with data manager. so I tried my hand at the front end to get the info required in a chart. sorry if this does not help in any way.

[Architect]

@G3S 

Thanks a lot for your reply.

1> I  was following your process but was facing issue with sorting, we should sort the rows on  rank(sum(sale)),

but it was always taking CustID  for sorting. Tried changing the parameters in Sorting tabs but no use.

2> My final target is to feed the data into one line chart or scatter plot.

how to do that? 

please check the file attached I have provided what output I am looking.

[G3S]

swapping CustID & ranking columns around could fix the first issue.

I have not been able to figure out the chart yet.. maybe adding rank into the chart and making it invisible (colour it white) might help. 

[G3S]

I have not worked with  variables in qlik. but that may work, if you can store each percentage of customer % in a variable and another variable for sales % chart might be feasible?