topic Re: Pivot table - Sort data on multiple dimensions in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-Sort-data-on-multiple-dimensions/m-p/138888#M20738 <HTML><HEAD></HEAD><BODY><P>How about this?</P><P></P><P><STRONG>Aggr(Sum(Sales), (Division, (NUMERIC)))</STRONG></P></BODY></HTML> Tue, 31 Jul 2018 12:58:47 GMT Anil_Babu_Samineni 2018-07-31T12:58:47Z Pivot table - Sort data on multiple dimensions https://community.qlik.com/t5/QlikView/Pivot-table-Sort-data-on-multiple-dimensions/m-p/138887#M20737 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I am creating a pivot table to show the top 10 customers by their sales value. To filter the customers using calculated dimension.</P><P></P><P>But i need to sort the top customers by their sales based on company and division.&nbsp; The data should be sorted for each division within the company. I have attached screenshot of the output expected.</P><P></P><P>Please let me know how to achieve the same.</P><P></P><P>Thank you.</P><P></P><P>Regards,</P><P>Viresh</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/209248_Capture.PNG" style="height: 330px; width: 620px;" /></P></BODY></HTML> Mon, 30 Jul 2018 10:36:11 GMT https://community.qlik.com/t5/QlikView/Pivot-table-Sort-data-on-multiple-dimensions/m-p/138887#M20737 vireshkolagimat 2018-07-30T10:36:11Z Re: Pivot table - Sort data on multiple dimensions https://community.qlik.com/t5/QlikView/Pivot-table-Sort-data-on-multiple-dimensions/m-p/138888#M20738 <HTML><HEAD></HEAD><BODY><P>How about this?</P><P></P><P><STRONG>Aggr(Sum(Sales), (Division, (NUMERIC)))</STRONG></P></BODY></HTML> Tue, 31 Jul 2018 12:58:47 GMT https://community.qlik.com/t5/QlikView/Pivot-table-Sort-data-on-multiple-dimensions/m-p/138888#M20738 Anil_Babu_Samineni 2018-07-31T12:58:47Z