xsl-list
[Top] [All Lists]

RE: using preceding-sibling to display subtotal row

2005-01-07 11:58:35
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(_at_)saxonica(_dot_)com>
Sent: Jan 7, 2005 11:12 AM
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
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/


--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--



--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--