ansaurus

Question

XSLT Pivot Table

Answer 1

A:

You should be able to use sum if you can use an xpath to select the attribute for the desired record(s).

Without knowing the structure of your input xml i don't know what this would be but I guess in your case something like <xsl:value-of select="sum(@cost)"/>

Chris R 2009-10-05 23:01:06

Answer 2

+1 A:

Because your current context node inside the loop is a Record element, you will need to ensure your 'sum' includes all Records with a matching PersonID attribute. Something like this should do:

<xsl:value-of select="sum(../Record[@PersonID=current()/@PersonID]/@Cost)" />

Or, because you know the current Record element is the first with a particular PersonID attribute, you could also do this in this case

<xsl:value-of select="number(@Cost) + sum(following-sibling::Record[@PersonID=current()/@PersonID]/@Cost)" />

Tim C 2009-10-06 07:41:35

Thanks for pointing out some syntax that I was unaware of. Only have spent a couple days with XSLT so far and all examples help!

jwarzech 2009-10-06 13:36:59

Answer 3

+1 A:

Easy - you where already there. See full solution below.

On a different note, I advise against the use of <xsl:for-each> in favor of <xsl:apply-templates>. The code gets a bit longer, but readability and code structure improves, IMHO.

<xsl:stylesheet 
  version="1.0" 
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
>
  <xsl:output method="html" indent="yes" encoding="UTF-8"/>

  <xsl:key name="Person" match="Record" use="@PersonID" />

  <xsl:template match="/">
    <html>
      <body>
        <h2>Costs Per Person</h2>
        <table border = "1">
          <thead>
            <tr>
               <th>ID</th>
               <th>Cost</th>
            </tr>
          </thead>
          <tbody>
            <xsl:apply-templates select="Records/Record" />
          </tbody>
        </table>
      </body>
    </html>
  </xsl:template>

  <xsl:template match="Records/Record">
    <xsl:variable name="thisGroup" select"key('Person', @PersonID)" />

    <xsl:if test="generate-id() = generate-id($thisGroup[1])">
      <tr>
        <td>
          <xsl:value-of select="@PersonID" />
        </td>
        <td>
          <!-- Sum Of Cost -->
          <xsl:value-of select="sum($thisGroup/@Cost)" />
        </td>
      </tr>   
    </xsl:if>  
  </xsl:template>
</xsl:stylesheet>

Tomalak 2009-10-06 09:23:13

That works, thanks for your help!

jwarzech 2009-10-06 13:37:30

ansaurus

tags:

views:

answers:

XSLT Pivot Table

related questions