This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

<@U76K4ER46> this is the basic idea (untested pseudo code)

thank you <@U29QCJQF3>, super helpful! its sorting my items correctly now, but still figuring out why the item level subtotal is not showing up

late in the day for me, i'm probably missing something basic here. but here's what i got to based on your pseudo code

```&lt;!-- start items --&gt;
&lt;#list record.item?sort_by('custcol_cseg1') as item&gt;
  &lt;#assign itemTotal = 0&gt;
  &lt;#assign lastGroup = ""&gt;
  &lt;#if lastGroup != "" &amp;&amp; lastGroup != item.custco_cseg1&gt;
  	&lt;tr&gt;
     &lt;td align="right" colspan="31"&gt;${itemTotal}&lt;/td&gt;
    &lt;/tr&gt;
    &lt;#assign itemTotal = 0&gt;
    &lt;#assign lastGroup = item.custcol_cseg1&gt;
  &lt;/#if&gt;
	&lt;tr&gt;
	&lt;td colspan="10" line-height="150%"&gt;${item.custcol_cseg1}&lt;/td&gt;
	&lt;td colspan="10"&gt;&lt;span class="itemname"&gt;${item.item}&lt;/span&gt;&lt;br /&gt;${item.description}&lt;/td&gt;
	&lt;td colspan="3"&gt;${item.quantity}&lt;/td&gt;
	&lt;td align="right" colspan="4"&gt;${item.rate}&lt;/td&gt;
	&lt;td align="right" colspan="4"&gt;${item.amount}&lt;/td&gt;
	&lt;/tr&gt;
    &lt;#assign itemTotal = itemTotal + item.amount&gt;
&lt;/#list&gt;&lt;!-- end items --&gt;&lt;/table&gt;```

I am on mobile but the first two `assign`s need to be outside the `list`