This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
grouping with sub-total
- From: Mulberry Technologies List Owner<xsl-list-owner at lists dot mulberrytech dot com>
- To: xsl-list <xsl-list at lists dot mulberrytech dot com>
- Date: Sun, 16 Jun 2002 11:29:24 -0400
- Subject: [xsl] grouping with sub-total
- Reply-to: xsl-list at lists dot mulberrytech dot com
>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