Subject: Re: [xsl] grouping with sub-total From: Bill Curtis <digitalmetrics@xxxxxxxxx> Date: Sun, 16 Jun 2002 09:26:19 -0700 (PDT) |
The ouput that I require got messed up.. This is what I actually want Sorry, the output got messed up... I want the output in this format. <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> Thanks Bill --- Mulberry Technologies List Owner <xsl-list-owner@xxxxxxxxxxxxxxxxxxxxxx> wrote: > >Date: Sun, 16 Jun 2002 07:24:51 -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 > > > > > > > > > ><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 > > > > > > > > > Y2001 > > > TOTAL > > > Y2002 TOTAL > >---------------------------------------------------|-----------------------------------------------|---------|--------------------------------------------|--------| > > > > > QTR1 QTR2 QTR3 > QTR4 > > QTR1 QTR2 QTR3 QTR4 > > > > >---------------------------------------------------|-----------------------------------------------|---------|--------------------------------------------|--------| > >USA NW > > > 0 0 0 0 > 0 > > 0 0 0 > > > 0 0 0 > > SE > > > 0 0 0 0 > > > 0 0 0 0 > > > 0 121 121 > > NE > > > 238 532 508 232 > 1510 > > 230 0 0 0 > > > 230 230 > > SW > > > 433 232 433 306 > 1404 > > 221 0 0 0 > > > 221 221 > >---------------------------------------------------|-----------------------------------------------|---------|--------------------------------------------|--------| > > Total for lev2 > > > 671 764 941 538 2914 > > > 452 0 0 0 > > >542 542 > > > > > >Next lev1 > > > > > > > >---------------------------------------------------|-----------------------------------------------|---------|--------------------------------------------|--------| > >Total for all levels > > > > > >I would appreciate any 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 > __________________________________________________ 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
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
[xsl] grouping with sub-total, Mulberry Technologie | Thread | [xsl] grouping with sub-total, B. Tommie Usdin |
[xsl] grouping with sub-total, Mulberry Technologie | Date | RE: [xsl] can templates be nested?, dmitri kerievsky |
Month |