topic Re: In a Pivot Chart, need to sort at multiple levels within that level in QlikView https://community.qlik.com/t5/QlikView/In-a-Pivot-Chart-need-to-sort-at-multiple-levels-within-that/m-p/56431#M510893 <HTML><HEAD></HEAD><BODY><P>Take a look on this: <A href="https://community.qlik.com/docs/DOC-7220">Perfectly Sorting Pivot Table (by A-Z. y-Value set for each dim-level)</A></P><P></P><P>- Marcus</P></BODY></HTML> Thu, 21 Jun 2018 08:10:11 GMT marcus_sommer 2018-06-21T08:10:11Z In a Pivot Chart, need to sort at multiple levels within that level https://community.qlik.com/t5/QlikView/In-a-Pivot-Chart-need-to-sort-at-multiple-levels-within-that/m-p/56430#M510892 <HTML><HEAD></HEAD><BODY><P>I need to sort sales by SOType, Series, CostType&nbsp; High to Low on Dollars within the Material cost type group</P><P>we want to see sales High to low within each group.</P><P></P><P>I cannot get the expression to work in the sort tab.</P><P>This is what I have in the expression on the CostType field:</P><P>Sum(total&lt;SOType,Series,CostType&gt;(SalesAmount))</P><P></P><P>Any help?</P></BODY></HTML> Wed, 20 Jun 2018 16:39:22 GMT https://community.qlik.com/t5/QlikView/In-a-Pivot-Chart-need-to-sort-at-multiple-levels-within-that/m-p/56430#M510892 suepenick 2018-06-20T16:39:22Z Re: In a Pivot Chart, need to sort at multiple levels within that level https://community.qlik.com/t5/QlikView/In-a-Pivot-Chart-need-to-sort-at-multiple-levels-within-that/m-p/56431#M510893 <HTML><HEAD></HEAD><BODY><P>Take a look on this: <A href="https://community.qlik.com/docs/DOC-7220">Perfectly Sorting Pivot Table (by A-Z. y-Value set for each dim-level)</A></P><P></P><P>- Marcus</P></BODY></HTML> Thu, 21 Jun 2018 08:10:11 GMT https://community.qlik.com/t5/QlikView/In-a-Pivot-Chart-need-to-sort-at-multiple-levels-within-that/m-p/56431#M510893 marcus_sommer 2018-06-21T08:10:11Z