0 Replies Latest reply: Jun 9, 2017 7:41 AM by Diego Corral RSS

    How many customers are the 80% of my Sales?

    Diego Corral

      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