I have a xml that looks like:

---snip---

<dts>
<output>
<total name="test_t">
  <total name="cState">
    <total name="date_range">
      <value >00-06 </value>
      <count>21</count>
    </total>
    <total name="date_range">
      <value >07-12 </value>
      <count>26</count>
    </total>
    <total name="date_range">
      <value>13-24 </value>
      <count>34</count>
    </total>
    <value>AK</value>
    <count>81</count>
  </total>
  <total name="cState">
    <total name="date_range">
      <value >00-06 </value>
      <count>50</count>
    </total>
    <total name="date_range">
      <value >07-12 </value>
      <count>10</count>
    </total>
    <total name="date_range">
      <value>13-24 </value>
      <count>40</count>
    </total>
    <value>AR</value>
    <count>100</count>
  </total>
  .
  .
  .
</total>
</output>
</dts>

---snip----

I'm seeeking help in using xslt for transformation/ retrieve data such that, to display the sum of "count" by "date_range" for all states.
For instance:

00-06 : 21
00-06 : 50
Total : 71

07-12 : 26
07-12 : 10
Total : 36

et cetera...

Any help and recommendations are highly anticipated.

Thanks

daula

This is a standard grouping problem. In XSLT 2.0 it's simply:

<xsl:for-each-group select="//total[@name='date_range']"
  group-by="value">
  <xsl:for-each select="current-group()">
    <tr>
      <td><xsl:value-of select="value"/></td>
      <td><xsl:value-of select="count"/></td>
    </tr>
  </xsl:for-each>
  <tr>
    <td>Total</td>
    <td><xsl:value-of select="sum(current-group()/count)"/></td>
  </tr>
</xsl:for-each>

If you're stuck with XSLT 1.0 then grouping is much harder, but there's plenty of advice at http://www.jenitennison.com/xslt/grouping (or in any decent XSLT textbook)

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Thanks for you input.
Unfortunetly, I'm using XSLT 1.0...
I browsed on the grouping topics in the link you posted but I couldn't figure a solution. Also, I being a newbie could be a big factor too.
Could there be a solution for this problem using XSLT 1.0??
Or will I need to reformat/ re-arrange the xml file??
Thanks again.

daula