This is the mail archive of the xsl-list@mulberrytech.com mailing list .


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]
Other format: [Raw text]

grouping with sub-total


>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


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]