#if record.item?has_content>
<#assign itemArray = [] >
<#assign amountArray = [] >
<#list record.item?sort_by("item") as item>
<#if item_index==0>
${item.item@label} |
|
${item.amount@label} |
#if>
<#assign itemName = item.item>
<#if itemName?has_content>
<#else>
<#assign itemName = item.description>
#if>
<#if itemArray?seq_contains(itemName)>
<#else>
<#assign itemArray = itemArray + [itemName]>
<#assign expTotal = 0>
<#list record.item?sort_by('item') as uniqueItem>
<#if uniqueItem.item?has_content>
<#if itemName == uniqueItem.item>
<#assign expTotal = expTotal + uniqueItem.amount>
#if>
<#else>
<#if itemName == uniqueItem.description>
<#assign expTotal = expTotal + uniqueItem.amount>
#if>
#if>
#list>
<#assign amountArray = amountArray + [expTotal]>
#if>
#list>
<#list itemArray as item>
${item} |
|
<#assign currentAmount = amountArray[item_index]>
$${currentAmount?string[",##0.00"]} |
#list>