Re: [xsl] grouping with sub-total

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