topic Re: How to order pivot table by a total field in QlikView https://community.qlik.com/t5/QlikView/How-to-order-pivot-table-by-a-total-field/m-p/452435#M568151 <HTML><HEAD></HEAD><BODY><P>Try not sorting HOT on Y-Value and sorting TTOO descending on =sum(I_PRODUCCION). As far as I can tell that sorts the table like you want.</P></BODY></HTML> Tue, 20 Nov 2012 17:50:57 GMT Gysbert_Wassenaar 2012-11-20T17:50:57Z How to order pivot table by a total field https://community.qlik.com/t5/QlikView/How-to-order-pivot-table-by-a-total-field/m-p/452434#M568150 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I 've attached my real file to finally know if it is possible to order 'TTOO' descending by 'TOTAL W + S' --&gt;'Prod.' </P><P></P><P>Thank you all</P></BODY></HTML> Tue, 20 Nov 2012 17:10:29 GMT https://community.qlik.com/t5/QlikView/How-to-order-pivot-table-by-a-total-field/m-p/452434#M568150 2012-11-20T17:10:29Z Re: How to order pivot table by a total field https://community.qlik.com/t5/QlikView/How-to-order-pivot-table-by-a-total-field/m-p/452435#M568151 <HTML><HEAD></HEAD><BODY><P>Try not sorting HOT on Y-Value and sorting TTOO descending on =sum(I_PRODUCCION). As far as I can tell that sorts the table like you want.</P></BODY></HTML> Tue, 20 Nov 2012 17:50:57 GMT https://community.qlik.com/t5/QlikView/How-to-order-pivot-table-by-a-total-field/m-p/452435#M568151 Gysbert_Wassenaar 2012-11-20T17:50:57Z Re: How to order pivot table by a total field https://community.qlik.com/t5/QlikView/How-to-order-pivot-table-by-a-total-field/m-p/452436#M568152 <HTML><HEAD></HEAD><BODY><P>I'm sorry I should have attached an exemple with several HOT.</P><P></P><P>You are right with the exemple I attached it shows the right order, but , when there are several 'HOT' how could I get the right descending order into each HOT? maybe I have to use 'aggr' but I do not understand exactly how.</P><P></P><P>Thanks</P></BODY></HTML> Tue, 20 Nov 2012 18:04:36 GMT https://community.qlik.com/t5/QlikView/How-to-order-pivot-table-by-a-total-field/m-p/452436#M568152 2012-11-20T18:04:36Z