[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] grouping with sub-total
>Date: Mon, 17 Jun 2002 04:34:43 -0700 (PDT) >From: Bill Curtis <digitalmetrics@xxxxxxxxx> >Subject: grouping with sub-total >To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx > >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
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|