topic Top 10 Customers using Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Top-10-Customers-using-Pivot-Table/m-p/178080#M45422 <HTML><HEAD></HEAD><BODY><P>Hi Oleg!</P><P>Any idea how to find the last 10 customer??? (Non performing customers)</P><P>Thanks and Regards,</P><P>Rikab</P><P></P></BODY></HTML> Wed, 24 Feb 2010 08:33:29 GMT 2010-02-24T08:33:29Z Top 10 Customers using Pivot Table https://community.qlik.com/t5/QlikView/Top-10-Customers-using-Pivot-Table/m-p/178078#M45420 <HTML><HEAD></HEAD><BODY><P style="margin: 0in 0in 10pt;">Hai,</P><P style="margin: 0in 0in 10pt;"></P><P style="margin: 0in 0in 10pt;">I'm trying to get the Top 10 customers in the straight table. So I have assigned 10 to Max Visible No. But the grand total shows the total customer's sales not for the top 10 customers. I want to display only 10 customer's grand total. Please suggest / advice me to get this.</P><P style="margin: 0in 0in 10pt;"></P><P style="margin: 0in 0in 10pt;">Thanks in advance..</P><P style="margin: 0in 0in 10pt;"></P><P style="margin: 0in 0in 10pt;"></P><P style="margin: 0in 0in 10pt;"></P></BODY></HTML> Tue, 08 Sep 2009 00:45:06 GMT https://community.qlik.com/t5/QlikView/Top-10-Customers-using-Pivot-Table/m-p/178078#M45420 2009-09-08T00:45:06Z Top 10 Customers using Pivot Table https://community.qlik.com/t5/QlikView/Top-10-Customers-using-Pivot-Table/m-p/178079#M45421 <HTML><HEAD></HEAD><BODY><P>You can use Set Analysis to only show you Customers with the Rank(sum(Sales)) &lt;=10. If you look at the last Sample within the "Set Analysis" article in the Help Section, you'll see a similar expression (except that it compares sales to a specific number and you will be ranking them instead).</P><P>cheers!</P></BODY></HTML> Tue, 08 Sep 2009 02:39:53 GMT https://community.qlik.com/t5/QlikView/Top-10-Customers-using-Pivot-Table/m-p/178079#M45421 Oleg_Troyansky 2009-09-08T02:39:53Z Top 10 Customers using Pivot Table https://community.qlik.com/t5/QlikView/Top-10-Customers-using-Pivot-Table/m-p/178080#M45422 <HTML><HEAD></HEAD><BODY><P>Hi Oleg!</P><P>Any idea how to find the last 10 customer??? (Non performing customers)</P><P>Thanks and Regards,</P><P>Rikab</P><P></P></BODY></HTML> Wed, 24 Feb 2010 08:33:29 GMT https://community.qlik.com/t5/QlikView/Top-10-Customers-using-Pivot-Table/m-p/178080#M45422 2010-02-24T08:33:29Z Top 10 Customers using Pivot Table https://community.qlik.com/t5/QlikView/Top-10-Customers-using-Pivot-Table/m-p/178081#M45423 <HTML><HEAD></HEAD><BODY><P>yeah troyansky can you help me tio i need the sintaxis function top helpme&nbsp; man</P></BODY></HTML> Wed, 22 Jun 2011 02:52:57 GMT https://community.qlik.com/t5/QlikView/Top-10-Customers-using-Pivot-Table/m-p/178081#M45423 2011-06-22T02:52:57Z