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

RE: [xsl] using preceding-sibling to display subtotal row


Subject: RE: [xsl] using preceding-sibling to display subtotal row
From: dmitrik@xxxxxxxxxxxxxx
Date: Fri, 7 Jan 2005 13:58:35 -0500 (EST)

this line gets the correct subtotal sum based on a group, so considered removing the sum and placing
in a for-each would
somehow have it display correctly in the grid. This does not work. What happens is the 
correct subtotal is displayed on each line, instead of once per group.

<xsl:value-of select="format-number(sum(../Trade[Customer= current()/Customer]/Step),'###,###,###,##0')"/></b></td>

is there a more specific grouping idea which addresses the placement of the correctly 
summed subtotal amount?

Thanks,
Dmitri





-----Original Message-----
From: Michael Kay <mike@xxxxxxxxxxxx>
Sent: Jan 7, 2005 11:12 AM
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject: RE: [xsl] using preceding-sibling to display subtotal row

> There are a list of elements, and the following code is 
> trying to create a new row to display subtotals.
> There might be any number of Customer rows. Is there a way to 
> check if I've reached the last customer, and then
> insert the subtotal row? The following code is inserting on 
> every row, instead of the last.

Sounds like a classic grouping problem - see
http://www.jenitennison.com/xslt/grouping

Don't think of this as "process all the rows, outputting a subtotal whenever
I reach the last customer in a group". Think of it as "process all the
groups; for each group, output each row in the group and then the subtotal
for the group".

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


Current Thread