[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] grouping with sub-total
>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
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|