topic Re: Question Re: Displaying Revenue from Top 20 Customers in Button in QlikView https://community.qlik.com/t5/QlikView/Question-Re-Displaying-Revenue-from-Top-20-Customers-in-Button/m-p/1243494#M394635 <HTML><HEAD></HEAD><BODY><P>Sorry, that should read top 10 customers</P></BODY></HTML> Thu, 09 Feb 2017 11:02:14 GMT 2017-02-09T11:02:14Z Question Re: Displaying Revenue from Top 20 Customers in Button https://community.qlik.com/t5/QlikView/Question-Re-Displaying-Revenue-from-Top-20-Customers-in-Button/m-p/1243493#M394634 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm currently trying to use a button to show the total Profitability from the Top 20 Customers. I have the current statement, however it is not working. I'm wondering if anyone would have a suggestion.</P><P></P><P>=sum({&lt;[Customer Name] = {'=Rank(sum(Amount*-1))&lt;=10'}, [Event Fiscal Year] = {'2016'}, [Event Profitability Code]={'019'} &gt;}Amount) * -1 - sum({&lt;[Customer Name] = {'=Rank(sum(Amount*-1))&lt;=10'}, [Event Fiscal Year] = {'2016'}, [Event Profitability Code]={'020', '021'} &gt;}Amount)</P><P></P><P>Kind Regards,</P><P><BR />Antoinette</P></BODY></HTML> Thu, 09 Feb 2017 10:58:17 GMT https://community.qlik.com/t5/QlikView/Question-Re-Displaying-Revenue-from-Top-20-Customers-in-Button/m-p/1243493#M394634 2017-02-09T10:58:17Z Re: Question Re: Displaying Revenue from Top 20 Customers in Button https://community.qlik.com/t5/QlikView/Question-Re-Displaying-Revenue-from-Top-20-Customers-in-Button/m-p/1243494#M394635 <HTML><HEAD></HEAD><BODY><P>Sorry, that should read top 10 customers</P></BODY></HTML> Thu, 09 Feb 2017 11:02:14 GMT https://community.qlik.com/t5/QlikView/Question-Re-Displaying-Revenue-from-Top-20-Customers-in-Button/m-p/1243494#M394635 2017-02-09T11:02:14Z