I'm very new in xml and xsl. I have been been doing some reading and exercises thru' some tutorials and examples. However, due to my meagre knowledge in xsl I need alot of help to come up with a xsl 1.0 solution to produce an extended summary like the following:

Range Count State
00-06 21 AK
00-06 50 AR

07-12 26 AK
07-12 10 AR

13-24 34 AK
13-24 40 AR

SUMMARY:
RANGE TOTAL
00-06 71
07-12 36
13-24 74

Gross: 181

Range %[of Gross]
00-06 39.22
07-12 19.88
13-24 40.88

My xml looks like the following...

---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 name="cState">
 .
 .
 .
 </total>
</total>
</output>
</dts>

---snip---

Thank you in advance for your help.

kinyash

It's difficult to respond to this kind of post because you don't say where you are having difficulties. If I know where your problems are then I can try and help you over them, but I'm not going to simply code the whole thing for you from scratch.

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