topic Change field order in Pivot table in QlikView https://community.qlik.com/t5/QlikView/Change-field-order-in-Pivot-table/m-p/488418#M553152 <HTML><HEAD></HEAD><BODY><P>In a Pivot table there are dimensions and formulas. In the properties of a pivot table dimensions can be order, formulas are following. How can I change the order of dimensions and formulas?</P><P></P><P>For example:</P><P>Dimensions: field1, field2, field3</P><P>Formulas: sum1, sum2</P><P></P><P>View in Pivot table: field1, field2, field3, sum1, sum2</P><P>New view: field1, field2, sum1, field3, sum2</P><P></P><P>Regards Stefan</P></BODY></HTML> Fri, 27 Sep 2013 11:37:32 GMT Anonymous 2013-09-27T11:37:32Z Change field order in Pivot table https://community.qlik.com/t5/QlikView/Change-field-order-in-Pivot-table/m-p/488418#M553152 <HTML><HEAD></HEAD><BODY><P>In a Pivot table there are dimensions and formulas. In the properties of a pivot table dimensions can be order, formulas are following. How can I change the order of dimensions and formulas?</P><P></P><P>For example:</P><P>Dimensions: field1, field2, field3</P><P>Formulas: sum1, sum2</P><P></P><P>View in Pivot table: field1, field2, field3, sum1, sum2</P><P>New view: field1, field2, sum1, field3, sum2</P><P></P><P>Regards Stefan</P></BODY></HTML> Fri, 27 Sep 2013 11:37:32 GMT https://community.qlik.com/t5/QlikView/Change-field-order-in-Pivot-table/m-p/488418#M553152 Anonymous 2013-09-27T11:37:32Z Re: Change field order in Pivot table https://community.qlik.com/t5/QlikView/Change-field-order-in-Pivot-table/m-p/488419#M553153 <HTML><HEAD></HEAD><BODY><P>I don't think it's possible to change the order like that.</P><P></P><P>If you want to show soemthing like subtotals or even different sums on different levels of aggregation, you can use partial sums (enable on presentation tab), and maybe dimensionality() function in a conditional to decide which expression to use.</P></BODY></HTML> Fri, 27 Sep 2013 11:41:19 GMT https://community.qlik.com/t5/QlikView/Change-field-order-in-Pivot-table/m-p/488419#M553153 swuehl 2013-09-27T11:41:19Z