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