I have got part of the problem working, but summation seems to be going wrong. I am getting the counts( no of books sold), but when I am trying to add them it just gets concatenated. Please help me on this issue. Thanks

Required Output:
*****************
JavaScript 64
Photoshop 6
*****************

Current Output:
*****************
JavaScript 2359
Photoshop 6
*****************

XML:

<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="stylesheet10.xsl"?>
   <bookstore>
     <book>
       <counts>2</counts>
       <title>JavaScript</title>
     </book>
     <book>
      <counts>3</counts>
      <title>JavaScript</title>
     </book>
     <book>
       <counts>6</counts>
       <title>Photoshop</title>
     </book>
      <book>
       <counts>59</counts>
       <title>JavaScript</title>
     </book>
   </bookstore>

XSLT:

<?xml version='1.0' encoding='utf-8' ?>
<xsl:stylesheet version="1.0"
                xmlns:xsl="http://www.w3.org/1999/XSL/Transform">


<xsl:key name="kbook" match="book" use="title"/>
<xsl:key name="crount" match="book" use="counts"/>

         <xsl:template match="/">
           <table>
             <xsl:apply-templates select="node()|@*"/>
           </table>
         </xsl:template>

   <xsl:template match="book">
    <xsl:if test="generate-id()=generate-id(key('kbook',title)[1])">
           <tr>
             <td>
                <xsl:value-of select="title"/>
             </td>

             <td>
          <xsl:for-each select="key('kbook', title)">
            <xsl:value-of select="sum(counts)"/>
        </xsl:for-each>
             </td>
           </tr>

         </xsl:if>
         </xsl:template>

     <xsl:template match="text()"/>

</xsl:stylesheet>

This:

<xsl:for-each select="key('kbook', title)">
            <xsl:value-of select="sum(counts)"/>
        </xsl:for-each>


says "for each of the books with this title, add up all the <counts> elements for this book and output the total. There's only one <counts> for each book, so that's the value you get.

What you want is a single value, not one for each book:

<xsl:value-of select="key('kbook', title)/counts"/>



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