topic a Ranking Sub total in QlikView https://community.qlik.com/t5/QlikView/a-Ranking-Sub-total/m-p/214989#M68469 <HTML><HEAD></HEAD><BODY><P></P><P>Hi All,</P><P></P><P>My report lists top 100 products sold by the company.</P><P>Report layout as following :</P><P>===============================</P><P>top 1</P><P>..</P><P>top 10</P><P>Subtotal of top 1 to top 10</P><P>top 11</P><P>..</P><P>..</P><P>top 20</P><P>Subtotal of top 11 to top 20</P><P>Grand total of top 100</P><P>===============================</P><P>Did anyone experience with that kind of report?any solution on that . Thanks</P><P></P><P>Regards,</P><P>Kenny</P><P></P><BR /><BR /></BODY></HTML> Thu, 14 Apr 2011 09:50:43 GMT 2011-04-14T09:50:43Z a Ranking Sub total https://community.qlik.com/t5/QlikView/a-Ranking-Sub-total/m-p/214989#M68469 <HTML><HEAD></HEAD><BODY><P></P><P>Hi All,</P><P></P><P>My report lists top 100 products sold by the company.</P><P>Report layout as following :</P><P>===============================</P><P>top 1</P><P>..</P><P>top 10</P><P>Subtotal of top 1 to top 10</P><P>top 11</P><P>..</P><P>..</P><P>top 20</P><P>Subtotal of top 11 to top 20</P><P>Grand total of top 100</P><P>===============================</P><P>Did anyone experience with that kind of report?any solution on that . Thanks</P><P></P><P>Regards,</P><P>Kenny</P><P></P><BR /><BR /></BODY></HTML> Thu, 14 Apr 2011 09:50:43 GMT https://community.qlik.com/t5/QlikView/a-Ranking-Sub-total/m-p/214989#M68469 2011-04-14T09:50:43Z a Ranking Sub total https://community.qlik.com/t5/QlikView/a-Ranking-Sub-total/m-p/214990#M68470 <HTML><HEAD></HEAD><BODY><P>Hi Kenny,</P><P>A Class of an Aggr in a pivot table should do the trick:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />=Class(Aggr(Rank(Sum(Sales)), Product), 10)<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P></P><P>Regards,</P><P></P><P></P><P>Stephen</P></BODY></HTML> Thu, 14 Apr 2011 10:55:33 GMT https://community.qlik.com/t5/QlikView/a-Ranking-Sub-total/m-p/214990#M68470 stephencredmond 2011-04-14T10:55:33Z