Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

dcorral87
New Contributor

How many customers are the 80% of my Sales?

Hi!

I need to show how many customers are the 80% of my total Sales in a text object in QlikSense. At the moment I have a pivot table by customers with a metric: rangesum( above( sum( Sales),0,rowno())) /sum(TOTAL Sales)  where you can see the % Accumulated Sales and with other metric that count the number of rows that follow the rule of % Accumulated Sales >80%, but now I need the figure in Text Object.

Can anyone help me?

Thanks in advance

Tags (2)