Count the accounts that make up 50% of sales

[Jagveer]

I have a straight table that shows sales total by account.

i need to display the top n accounts in a text box that make up 50% of the revenue

for eg.

A1-$1500

A2$1200

A3$1000

A4$800

A5$500

so the text box should show 2 as the first 2 accounts make up for 50% or more sales.

please help

[TiagoCardoso · Accepted solution]

Maybe helpful.

https://community.qlik.com/t5/New-to-Qlik-Sense/Count-of-products-that-generate-50-of-sales-as-a-KPI...

[Jagveer]

Thanks for the reply, but in some cases the results are weird 

for some salesmen the count of accounts for YTD is 1 less than QTD which is not possible for eg.

              50%   60%  70%  80%  90%  100%

QTD        1         3        3          4         5         6

YTD        1         3        3          4         5         5