I followed this thread: http://www.dotnetnuke.com/Resources/F...   and learned a lot about grouping and totaling, (and more about FNL) but now, what would seem to be the simplest part is evading me.

My data table is a group of scouts going camping.
I'm grouping on campsite and summing the number of adults and youth in each campsite and also the combined total.   I summed the total in each campsite.
My field data are all calculated columns and I can't get the output to sort on any field.

I did this

<?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" />
<xsl:key name="data-by-campsite" match="udt:Data" use="udt:Campsite" />
<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 class="Normal">
<td>
<xsl:value-of select="udt:Campsite" disable-output-escaping="yes" />
</td>
<td>
<div class="row" style="text-align:right">
<xsl:variable name="ycampsite" select="udt:Campsite" />
<xsl:value-of select="sum(//udt:Data[udt:Campsite=$ycampsite]/udt:Youth)" disable-output-escaping="yes" />
</div>
</td>
<td>
<div class="row" style="text-align:right">
<xsl:variable name="acampsite" select="udt:Campsite" />
<xsl:value-of select="sum(//udt:Data[udt:Campsite=$acampsite]/udt:Adults)" disable-output-escaping="yes" />
</div>
</td>
<td>
<div class="row" style="text-align:right">
<xsl:variable name="tcampsite" select="udt:Campsite" />
<xsl:value-of select="sum(//udt:Data[udt:Campsite=$tcampsite]/udt:Total)" disable-output-escaping="yes" />
</div>
</td>
</tr>
</xsl:template>
<xsl:template match="/udt:UserDefinedTable">
<xsl:variable name="currentData" select="udt:Data[count(. | key('data-by-campsite', udt:Campsite)[1]) = 1]" />
<xsl:if test="$currentData">
<table>
<tr>
<th>Campsite</th>
<th>Youth</th>
<th>Adults</th>
<th>Total</th>
</tr>
<xsl:apply-templates select="$currentData" mode="list">
<xsl:sort select="tyouth" data-type="number" order="ascending" />
</xsl:apply-templates>
</table>
</xsl:if>
</xsl:template>
</xsl:stylesheet>

All learning opportunities are appreciated.

Kevin