https://community.jmp.com/t5/Discussions/Table-sort-by-multiple-columns/m-p/774304#M95595 <P>Use <A href="https://www.jmp.com/support/help/en/18.0/#page/jmp/sort-data-tables.shtml" target="_blank" rel="noopener">Sort platform</A></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_0-1721479198026.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/66338i304F00C76AC94BCB/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_0-1721479198026.png" alt="jthi_0-1721479198026.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_1-1721479205997.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/66339iFA491ED6728A7A8B/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_1-1721479205997.png" alt="jthi_1-1721479205997.png" /></span></P> <P>&nbsp;</P> Sat, 20 Jul 2024 12:40:39 GMT jthi 2024-07-20T12:40:39Z https://community.jmp.com/t5/Discussions/Table-sort-by-multiple-columns/m-p/774289#M95592 <P>How can I sort a table by multiple columns.<BR /><BR />In a <STRONG>data table</STRONG>, when I select multiple columns and sort the table via right click:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="hogi_0-1721478591886.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/66336i38EE12EBE1DF8A1F/image-size/medium?v=v2&amp;px=400" role="button" title="hogi_0-1721478591886.png" alt="hogi_0-1721478591886.png" /></span></P><P>&nbsp;</P><P>the table is always sorted from "left to right" - the sort column on the left is the dominant one<BR />... even if I change the order in which I select the columns.</P><P>&nbsp;</P><P>Via JSL, I can adjust the order:</P><PRE><CODE class=" language-jsl">dt &lt;&lt; Sort(By( :sex, :age )); dt &lt;&lt; Sort(By( :age, :sex ));</CODE></PRE><P>How to do the trick via the GUI?</P><P>&nbsp;</P><P>Another question:<BR />How to sort <STRONG>TableBoxes</STRONG> by multiple columns?</P> Sat, 20 Jul 2024 12:35:01 GMT https://community.jmp.com/t5/Discussions/Table-sort-by-multiple-columns/m-p/774289#M95592 hogi 2024-07-20T12:35:01Z https://community.jmp.com/t5/Discussions/Table-sort-by-multiple-columns/m-p/774304#M95595 <P>Use <A href="https://www.jmp.com/support/help/en/18.0/#page/jmp/sort-data-tables.shtml" target="_blank" rel="noopener">Sort platform</A></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_0-1721479198026.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/66338i304F00C76AC94BCB/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_0-1721479198026.png" alt="jthi_0-1721479198026.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_1-1721479205997.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/66339iFA491ED6728A7A8B/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_1-1721479205997.png" alt="jthi_1-1721479205997.png" /></span></P> <P>&nbsp;</P> Sat, 20 Jul 2024 12:40:39 GMT https://community.jmp.com/t5/Discussions/Table-sort-by-multiple-columns/m-p/774304#M95595 jthi 2024-07-20T12:40:39Z