https://community.qlik.com/t5/App-Development/Sorting-Pivot-Table-by-Measure/m-p/1670506#M50669 <P>It seems that you can't put the names of the measures at the top level.</P><P>How can I sort the pivot table at the bottom that it look likes the table below?</P><TABLE><TBODY><TR><TD>&nbsp;</TD><TD>Conversion</TD><TD>Lead to Quote</TD></TR><TR><TD>&nbsp;</TD><TD>2019</TD><TD>2020</TD><TD>2019</TD><TD>2020</TD></TR><TR><TD>Claims &amp; Convictions</TD><TD>14.23%</TD><TD>0.00%</TD><TD>19.09%</TD><TD>35.00%</TD></TR><TR><TD>Clean Risk</TD><TD>28.14%</TD><TD>29.61%</TD><TD>9.92%</TD><TD>5.63%</TD></TR><TR><TD>Conviction Free</TD><TD>18.69%</TD><TD>22.66%</TD><TD>27.19%</TD><TD>9.81%</TD></TR><TR><TD>Conviction Only 1 Conviction</TD><TD>16.34%</TD><TD>10.91%</TD><TD>19.85%</TD><TD>7.30%</TD></TR><TR><TD>Conviction Only 2 Plus</TD><TD>11.11%</TD><TD>0.00%</TD><TD>12.31%</TD><TD>0.00%</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Annotation 2020-01-29 141438.png" style="width: 894px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/27661i2CF1726B8701D497/image-size/large?v=v2&amp;px=999" role="button" title="Annotation 2020-01-29 141438.png" alt="Annotation 2020-01-29 141438.png" /></span></P> Sat, 16 Nov 2024 19:12:46 GMT Francisco_SP 2024-11-16T19:12:46Z https://community.qlik.com/t5/App-Development/Sorting-Pivot-Table-by-Measure/m-p/1670506#M50669 <P>It seems that you can't put the names of the measures at the top level.</P><P>How can I sort the pivot table at the bottom that it look likes the table below?</P><TABLE><TBODY><TR><TD>&nbsp;</TD><TD>Conversion</TD><TD>Lead to Quote</TD></TR><TR><TD>&nbsp;</TD><TD>2019</TD><TD>2020</TD><TD>2019</TD><TD>2020</TD></TR><TR><TD>Claims &amp; Convictions</TD><TD>14.23%</TD><TD>0.00%</TD><TD>19.09%</TD><TD>35.00%</TD></TR><TR><TD>Clean Risk</TD><TD>28.14%</TD><TD>29.61%</TD><TD>9.92%</TD><TD>5.63%</TD></TR><TR><TD>Conviction Free</TD><TD>18.69%</TD><TD>22.66%</TD><TD>27.19%</TD><TD>9.81%</TD></TR><TR><TD>Conviction Only 1 Conviction</TD><TD>16.34%</TD><TD>10.91%</TD><TD>19.85%</TD><TD>7.30%</TD></TR><TR><TD>Conviction Only 2 Plus</TD><TD>11.11%</TD><TD>0.00%</TD><TD>12.31%</TD><TD>0.00%</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Annotation 2020-01-29 141438.png" style="width: 894px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/27661i2CF1726B8701D497/image-size/large?v=v2&amp;px=999" role="button" title="Annotation 2020-01-29 141438.png" alt="Annotation 2020-01-29 141438.png" /></span></P> Sat, 16 Nov 2024 19:12:46 GMT https://community.qlik.com/t5/App-Development/Sorting-Pivot-Table-by-Measure/m-p/1670506#M50669 Francisco_SP 2024-11-16T19:12:46Z https://community.qlik.com/t5/App-Development/Sorting-Pivot-Table-by-Measure/m-p/1670522#M50670 <P>Sorry I only had to put Values at the top level in 'Column'</P> Wed, 29 Jan 2020 14:55:43 GMT https://community.qlik.com/t5/App-Development/Sorting-Pivot-Table-by-Measure/m-p/1670522#M50670 Francisco_SP 2020-01-29T14:55:43Z