Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Architect
Partner - Creator
Partner - Creator

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

'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'.

Architect_0-1694864614203.png

 

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 

 

Labels (5)
1 Reply
Architect
Partner - Creator
Partner - Creator
Author

@sunny_talwar  can you please have a look.