This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
Re: grouping with sub-total
- From: Bill Curtis <digitalmetrics at yahoo dot com>
- To: xsl-list at lists dot mulberrytech dot com
- Date: Sun, 16 Jun 2002 09:26:19 -0700 (PDT)
- Subject: Re: [xsl] grouping with sub-total
- Reply-to: xsl-list at lists dot mulberrytech dot com
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@lists.mulberrytech.com> wrote:
> >Date: Sun, 16 Jun 2002 07:24:51 -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
> >
> >
> >
> >
> ><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