https://community.qlik.com/t5/QlikView/Pivot-table-sorting/m-p/1699786#M724645 <P>Hello all,</P><P>I am currently working with pivot table in qlikview&nbsp; and the order is location&gt;route&gt;delivery&gt;product</P><P>and I want it sorted in descending order of the metric all of dimension</P><P>eg: 1st location in desc order of metric ,if user expands single location it should display route of selected location in desc order and so on with delivery and product</P><P>I used metric expression to sort it but didn't work&nbsp;</P><P>any other method to do so</P><P>Regards</P><P>Vishal Singh</P> Wed, 25 Nov 2020 16:16:04 GMT VishalSingh18 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Pivot-table-sorting/m-p/1699786#M724645 <P>Hello all,</P><P>I am currently working with pivot table in qlikview&nbsp; and the order is location&gt;route&gt;delivery&gt;product</P><P>and I want it sorted in descending order of the metric all of dimension</P><P>eg: 1st location in desc order of metric ,if user expands single location it should display route of selected location in desc order and so on with delivery and product</P><P>I used metric expression to sort it but didn't work&nbsp;</P><P>any other method to do so</P><P>Regards</P><P>Vishal Singh</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Pivot-table-sorting/m-p/1699786#M724645 VishalSingh18 2020-11-25T16:16:04Z