Hello..
You could try to create an XSLT form and use the following as an example. You'll need to edit it accordingly. If you need a good XML editor, look at getting and installing
Notepad++; works very well.
I use something similar for totally the values of census data at the bottom of the table.
Hope this helps. -Jeff
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:udt="DotNetNuke/UserDefinedTable" exclude-result-prefixes="udt">
<xsl:output method="xml" indent="yes" omit-xml-declaration="yes" />
<!--
This prefix is used to generate module specific query strings
Each querystring or form value that starts with udt_{ModuleId}_param
will be added as parameter starting with param
-->
<xsl:variable name="prefix_param">udt_<xsl:value-of select="//udt:Context/udt:ModuleId" />_param</xsl:variable>
<xsl:template match="udt:Data" mode="list">
<tr>
<td>
<xsl:call-template name="EditLink" />
</td>
<td>
<xsl:value-of select="udt:Name1" disable-output-escaping="yes" />
</td>
<td>
<xsl:value-of select="udt:Name2" disable-output-escaping="yes" />
</td>
<td>
<xsl:value-of select="udt:Name3" disable-output-escaping="yes" />
</td>
<td>
<xsl:value-of select="format-number(udt:Cost, '#,###.##')" disable-output-escaping="yes" />
</td>
</tr>
</xsl:template>
<xsl:template match="/udt:UserDefinedTable">
<xsl:variable name="currentData" select="udt:Data" />
<xsl:if test="$currentData">
<table class="InfoTable" border="1">
<tr>
<td style="border-color: #ffffff;">
<p> </p>
</td>
<td class="TopRow">
Name 1
</td>
<td class="TopRow">
Name 2
</td>
<td class="TopRow">
Name 3
</td>
<td class="TopRow">
Cost
</td>
</tr>
<xsl:apply-templates select="$currentData" mode="list">
</xsl:apply-templates>
<tr>
<td colspan="3"> </td>
<td style="font-weight: bold;">
<p>Totals:</p>
</td>
<td style="font-weight: bold;">
<xsl:value-of select="format-number(sum(//udt:Data/udt:Cost), '#,###.##')" />
</td>
</tr>
</table>
</xsl:if>
</xsl:template>
<xsl:template name="EditLink">
<xsl:if test="udt:EditLink">
<a href="{udt:EditLink}">
<img border="0" alt="edit" src="{//udt:Context/udt:ApplicationPath}/images/edit.gif" />
</a>
</xsl:if>
</xsl:template>
</xsl:stylesheet>