[XSL-LIST Mailing List Archive Home] [By Thread] [By Date]

RE: [xsl] for-each and summing based on group


Subject: RE: [xsl] for-each and summing based on group
From: "Michael Kay" <mike@xxxxxxxxxxxx>
Date: Wed, 5 Jan 2005 09:50:43 -0000

First read up about standard grouping techniques such as Muenchian grouping
at http://www.jenitennison.com/xslt/grouping

Computing a subtotal for each group is then a minor variant of the
technique: instead of merely iterating over the items in the group using
xsl:for-each, you can assign the node-set comprising the group to a
variable, and then sum over that using the sum() function.

Like all grouping problems, it's much easier in 2.0:

<xsl:for-each-group select="rows" group-by="columnA">
  <xsl:apply-templates select="current-group()"/>
  <subtotal><xsl:value-of select="sum(current-group()/columnB)"/></subtotal>
</xsl:for-each-group>

Michael Kay
http://www.saxonica.com/ 

> -----Original Message-----
> From: dsk [mailto:dmitrik@xxxxxxxxxxxxxx] 
> Sent: 05 January 2005 04:09
> To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> Subject: [xsl] for-each and summing based on group
> 
> 
> within a for-each there might be various sets of values which 
> produce the 
> following grid, where val is equal to a number
> 
> a  val val val
> a  val val val
> a  val val val
> b  val val val
> b  val val val
> c  val val val
> c  val val val
> 
> what is the best way to insert a sum line for the first
> column a, one for b, and one for c.
> 
> is a nested for each needed? or checking to see if the 
> following value is 
> not equal to the preceding, then then summing?
> 
> thanks,
> Dmitri
> 
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.802 / Virus Database: 545 - Release Date: 11/26/2004


Current Thread