https://community.qlik.com/t5/App-Development/PivotTable-Sorting/m-p/1548828#M39532 <P>i think doing something like in the scrip:</P><P>&nbsp;</P><P>autonumber(Cost Center) as SortField</P><P>and use "SortField" for sorting.</P><P>&nbsp;</P><P>regards</P> Mon, 25 Feb 2019 16:59:45 GMT sebastianfaust 2019-02-25T16:59:45Z https://community.qlik.com/t5/App-Development/PivotTable-Sorting/m-p/1548820#M39529 <P>I want to sort my pivottable so that all employees from a cost center are grouped together.&nbsp;</P><P>&nbsp;</P><P>In the image below, there are gaps between the employees for CC 2138 - Final Assembly because of the Employee Name field sort. I've tried overriding the Employee Name sort by using the sort by expression feature. I've put the cost center field there, the employee name, i've tried aggregating a measure by cost center or employee name. Nothing has worked so far.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="pivottable sort.JPG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/6691i803B6817095C36C5/image-size/large?v=v2&amp;px=999" role="button" title="pivottable sort.JPG" alt="pivottable sort.JPG" /></span></P> Sat, 16 Nov 2024 21:21:05 GMT https://community.qlik.com/t5/App-Development/PivotTable-Sorting/m-p/1548820#M39529 WiscoSippi 2024-11-16T21:21:05Z https://community.qlik.com/t5/App-Development/PivotTable-Sorting/m-p/1548828#M39532 <P>i think doing something like in the scrip:</P><P>&nbsp;</P><P>autonumber(Cost Center) as SortField</P><P>and use "SortField" for sorting.</P><P>&nbsp;</P><P>regards</P> Mon, 25 Feb 2019 16:59:45 GMT https://community.qlik.com/t5/App-Development/PivotTable-Sorting/m-p/1548828#M39532 sebastianfaust 2019-02-25T16:59:45Z