https://community.jmp.com/t5/Discussions/Hide-and-exclude-last-row/m-p/806322#M98478 <PRE><CODE class=" language-jsl">dt &lt;&lt; Clear Select &lt;&lt; Select Rows(N Rows(dt)) &lt;&lt; Hide and Exclude(1) &lt;&lt; clear select;</CODE></PRE> Wed, 16 Oct 2024 18:17:40 GMT jthi 2024-10-16T18:17:40Z https://community.jmp.com/t5/Discussions/Hide-and-exclude-last-row/m-p/806290#M98476 <P>I am using tabulate function with add aggregate statistics and convert that in to the JMP table. How can I hide and exclude last row (Total) using script?&nbsp;</P><P>&nbsp;</P><P>last row number is different for different tables so I can't use:&nbsp;&nbsp;dt&lt;&lt; Clear Select &lt;&lt; Select Rows( [19] ) &lt;&lt;Hide and Exclude;</P> Wed, 16 Oct 2024 17:51:36 GMT https://community.jmp.com/t5/Discussions/Hide-and-exclude-last-row/m-p/806290#M98476 ConfidenceOwl94 2024-10-16T17:51:36Z https://community.jmp.com/t5/Discussions/Hide-and-exclude-last-row/m-p/806322#M98478 <PRE><CODE class=" language-jsl">dt &lt;&lt; Clear Select &lt;&lt; Select Rows(N Rows(dt)) &lt;&lt; Hide and Exclude(1) &lt;&lt; clear select;</CODE></PRE> Wed, 16 Oct 2024 18:17:40 GMT https://community.jmp.com/t5/Discussions/Hide-and-exclude-last-row/m-p/806322#M98478 jthi 2024-10-16T18:17:40Z