This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
grouping with sub-total
- From: "B. Tommie Usdin" <btusdin at mulberrytech dot com>
- To: xsl-list <xsl-list at lists dot mulberrytech dot com>
- Date: Mon, 17 Jun 2002 09:55:25 -0400
- Subject: [xsl] grouping with sub-total
- Reply-to: xsl-list at lists dot mulberrytech dot com
>Date: Mon, 17 Jun 2002 04:34:43 -0700 (PDT)
>From: Bill Curtis <digitalmetrics@yahoo.com>
>Subject: grouping with sub-total
>To: xsl-list@lists.mulberrytech.com
>
>Hi All
>
>
>I am having a tough time doing a sub total for each
>group at different levels. I have been able to group
>the different levels using variables. I want to do a
>sub total for each 'QTR' for each 'lev2' for 'Y2002'
>and 'Y2001'. I also want a total for each 'lev2' for
>'Y2002' and 'Y2001'
>
>
>xml file looks like this :
>
><rs:data>
> <z:row lev1="USA" lev2="NW" QTR="1" Y2002="0"
>Y2001="0"/>
> <z:row lev1="USA" lev2="NW" QTR="2" Y2002="0"
>Y2001="0"/>
> <z:row lev1="USA" lev2="NW" QTR="3" Y2002="0"
>Y2001="0"/>
> <z:row lev1="USA" lev2="NW" QTR="4" Y2002="0"
>Y2001="0"/>
> <z:row lev1="USA" lev2="SE" QTR="1" Y2002="121"
>Y2001="0"/>
> <z:row lev1="USA" lev2="SE" QTR="2" Y2002="0"
>Y2001="0"/>
> <z:row lev1="USA" lev2="SE" QTR="3" Y2002="0"
>Y2001="0"/>
> <z:row lev1="USA" lev2="SE" QTR="4" Y2002="0"
>Y2001="0"/>
> <z:row lev1="USA" lev2="NE" QTR="1" Y2002="230"
>Y2001="238"/>
> <z:row lev1="USA" lev2="NE" QTR="2" Y2002="0"
>Y2001="532"/>
> <z:row lev1="USA" lev2="NE" QTR="3" Y2002="0"
>Y2001="508"/>
> <z:row lev1="USA" lev2="NE" QTR="4" Y2002="0"
>Y2001="232"/>
> <z:row lev1="USA" lev2="SW" QTR="1" Y2002="221"
>Y2001="433"/>
> <z:row lev1="USA" lev2="SW" QTR="2" Y2002="0"
>Y2001="232"/>
> <z:row lev1="USA" lev2="SW" QTR="3" Y2002="0"
>Y2001="433"/>
> <z:row lev1="USA" lev2="SW" QTR="4" Y2002="0"
>Y2001="306"/>
>. . . . .
>
></rs:data>
>
>I am expecting a html output like this:
>
>
><TABLE cellSpacing=0 cellPadding=0 width=768 border=0>
>
> <TR>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD></TR>
> <TR>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD>Y2001</TD>
> <TD></TD>
> <TD></TD>
> <TD>TOTAL</TD>
> <TD></TD>
> <TD>Y2002</TD>
> <TD></TD>
> <TD></TD>
> <TD>TOTAL</TD></TR>
> <TR>
> <TD></TD>
> <TD></TD>
> <TD>QTR1</TD>
> <TD>QTR2</TD>
> <TD>QTR3</TD>
> <TD>QTR4</TD>
> <TD></TD>
> <TD>QTR1</TD>
> <TD>QTR2</TD>
> <TD>QTR3</TD>
> <TD>QTR4</TD>
> <TD></TD></TR>
> <TR>
> <TD>USA</TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD></TR>
> <TR>
> <TD></TD>
> <TD>NW</TD>
> <TD>0</TD>
> <TD>0</TD>
> <TD>0</TD>
> <TD>0</TD>
> <TD>0</TD>
> <TD>0</TD>
> <TD>0</TD>
> <TD>0</TD>
> <TD>0</TD>
> <TD>0</TD></TR>
> <TR>
> <TD></TD>
> <TD>SE</TD>
> <TD>0</TD>
> <TD>0</TD>
> <TD>0</TD>
> <TD>0</TD>
> <TD>0</TD>
> <TD>121</TD>
> <TD>0</TD>
> <TD>0</TD>
> <TD>0</TD>
> <TD>121</TD></TR>
> <TR>
> <TD></TD>
> <TD>NE</TD>
> <TD>238</TD>
> <TD>532</TD>
> <TD>508</TD>
> <TD>232</TD>
> <TD>1510</TD>
> <TD>230</TD>
> <TD>0</TD>
> <TD>0</TD>
> <TD>0</TD>
> <TD>230</TD></TR>
> <TR>
> <TD></TD>
> <TD>SW</TD>
> <TD>433</TD>
> <TD>232</TD>
> <TD>433</TD>
> <TD>306</TD>
> <TD>1404</TD>
> <TD>221</TD>
> <TD>0</TD>
> <TD>0</TD>
> <TD>0</TD>
> <TD>221</TD></TR>
> <TR>
> <TD></TD>
> <TD>TOTAL</TD>
> <TD>671</TD>
> <TD>764</TD>
> <TD>941</TD>
> <TD>538</TD>
> <TD>2914</TD>
> <TD>572</TD>
> <TD>0</TD>
> <TD>0</TD>
> <TD>0</TD>
> <TD>572</TD></TR>
> <TR>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD></TR>
> <TR>
> <TD>TOTAL</TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD></TR>
> <TR>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD>
> <TD></TD></TR></TABLE>
>
>I would appreciate any help or suggestions.
>
>Thanks
>Bill
>
>
>__________________________________________________
>Do You Yahoo!?
>Yahoo! - Official partner of 2002 FIFA World Cup
>http://fifaworldcup.yahoo.com
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list