Subject: RE: outputting unique titles and partial sums
From: "Michael Kay" <mhkay@xxxxxxxxxxxx>
Date: Mon, 6 Aug 2001 18:16:44 +0100
|
> And I want to
> get a list of unique months and the sum of num_spots for
> these months. Here
> is my code:
>
>
> <xsl:variable name="month-list"
> select="//month_name[not(.=following::month_name) and
> not(.='')]" />
>
> <xsl:variable name="monthsum">
> <xsl:for-each select="$month-list">
> <xsl:variable name="monthname" select="."/>
> <xsl:value-of select="$monthname"/>
> <xsl:text>:</xsl:text>
> <xsl:value-of
> select="//air_month[month_name=$monthname]/num_spots"/>
that will give you the first num_spots for the month. If you want the sum of
all the num_spots, write
<xsl:value-of
select="sum(//air_month[month_name=$monthname]/num_spots)"/>
Incidentally, defining a key on month_name would help it go much faster, but
this depends on document size.
Mike Kay
Software AG
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
|