[xsl] grouping with sub-total

Subject: [xsl] grouping with sub-total
From: Mulberry Technologies List Owner <xsl-list-owner@xxxxxxxxxxxxxxxxxxxxxx>
Date: Sun, 16 Jun 2002 11:29:24 -0400
>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


Current Thread