Totals
"Yoshida, Ken" <[email protected]> Wed, 16 Apr 2003 10:09:19 -0400
| Newsgroups | gmane.text.xml.xsl.general |
|---|---|
| Message-ID | <[email protected]> |
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C30421.C57B7460 Content-Type: text/plain; charset="iso-8859-1" I want to group and sub-total based on a SBU - Strategic Business Unit: <Customer> < <CustomerNumber>12345</CustomerNumber> < <CustomerName> CORPORATION</CustomerName> < <SBU>F</SBU> < <OrderNumber>12345</OrderNumber> < <ItemNumber>12345</ItemNumber> < <ItemDesc>Test</ItemDesc> < <LOD>12/12/02</LOD> < <PreInc>35.17</PreInc> < <PostInc>37.37</PostInc> < <ChangeAmount>2.20</ChangeAmount> < <ChangePercentage>6.26%</ChangePercentage> </Customer> There are 4 different SBU's and I want to sub-total at the end of each SBU. How can I do this? ------_=_NextPart_001_01C30421.C57B7460 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <html xmlns:o=3D"urn:schemas-microsoft-com:office:office" = xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" = xmlns=3D"http://www.w3.org/TR/REC-html40"> <head> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <meta name=3DProgId content=3DWord.Document> <meta name=3DGenerator content=3D"Microsoft Word 10"> <meta name=3DOriginator content=3D"Microsoft Word 10"> <link rel=3DFile-List href=3D"cid:[email protected]"> <o:SmartTagType = namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" name=3D"date"/> <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:DoNotRelyOnCSS/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:SpellingState>Clean</w:SpellingState> <w:GrammarState>Clean</w:GrammarState> <w:DocumentKind>DocumentEmail</w:DocumentKind> <w:EnvelopeVis/> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if !mso]> <style> st1\:*{behavior:url(#default#ieooui) } </style> <![endif]--> <style> <!-- /* Font Definitions */ @font-face {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:536871559 0 0 0 415 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline; text-underline:single;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline; text-underline:single;} span.EmailStyle17 {mso-style-type:personal-compose; mso-style-noshow:yes; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt; font-family:Arial; mso-ascii-font-family:Arial; mso-hansi-font-family:Arial; mso-bidi-font-family:Arial; color:windowtext;} span.m1 {mso-style-name:m1; color:blue;} span.t1 {mso-style-name:t1; color:#990000;} span.b1 {mso-style-name:b1; font-family:"Courier New"; mso-ascii-font-family:"Courier New"; mso-hansi-font-family:"Courier New"; mso-bidi-font-family:"Courier New"; color:red; mso-text-animation:none; font-weight:bold; text-decoration:none; text-underline:none; text-decoration:none; text-line-through:none;} span.tx1 {mso-style-name:tx1; font-weight:bold;} span.SpellE {mso-style-name:""; mso-spl-e:yes;} span.GramE {mso-style-name:""; mso-gram-e:yes;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style> <!--[if gte mso 10]> <style> /* Style Definitions */=20 table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman";} </style> <![endif]--> </head> <body lang=3DEN-US link=3Dblue vlink=3Dpurple = style=3D'tab-interval:.5in'> <div class=3DSection1> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>I want to group and sub-total based on a SBU - Strategic Business Unit:<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'><o:p> </o:p></span></font></p> <p class=3DMsoNormal style=3D'text-indent:-12.0pt'><span = class=3Db1><b><font size=3D2 color=3Dred face=3D"Courier New"><span = style=3D'font-size:10.0pt'> </span></font></b></span><span class=3Dm1><font size=3D2 color=3Dblue face=3DVerdana><span = style=3D'font-size:10.0pt; font-family:Verdana'><</span></font></span><span class=3Dt1><font = size=3D2 color=3D"#990000" face=3DVerdana><span = style=3D'font-size:10.0pt;font-family:Verdana'>Customer</span></font></s= pan><span class=3Dm1><font size=3D2 color=3Dblue face=3DVerdana><span = style=3D'font-size:10.0pt; font-family:Verdana'>></span></font></span><font size=3D2 = face=3DVerdana><span style=3D'font-size:10.0pt;font-family:Verdana'><o:p></o:p></span></font>= </p> <p class=3DMsoNormal style=3D'text-indent:-24.0pt'><span = class=3Db1><b><font size=3D2 color=3Dred face=3D"Courier New"><span = style=3D'font-size:10.0pt'> </span></font></b></span><font size=3D2 face=3DVerdana><span = style=3D'font-size:10.0pt;font-family:Verdana'> <span class=3Dm1><font color=3Dblue><<span style=3D'mso-tab-count:1'>=A0 = </span><</font></span><span class=3DSpellE><span class=3Dt1><font = color=3D"#990000">CustomerNumber</font></span></span><span class=3Dm1><font color=3Dblue>></font></span><span = class=3Dtx1><b>12345</b></span><span class=3Dm1><font color=3Dblue></</font></span><span = class=3DSpellE><span class=3Dt1><font color=3D"#990000">CustomerNumber</font></span></span><span = class=3Dm1><font color=3Dblue>></font></span> <o:p></o:p></span></font></p> <p class=3DMsoNormal style=3D'text-indent:-24.0pt'><span = class=3Db1><b><font size=3D2 color=3Dred face=3D"Courier New"><span = style=3D'font-size:10.0pt'> </span></font></b></span><font size=3D2 face=3DVerdana><span = style=3D'font-size:10.0pt;font-family:Verdana'> <span class=3Dm1><font color=3Dblue><<span style=3D'mso-tab-count:1'>=A0 = </span><</font></span><span class=3DSpellE><span class=3Dt1><font = color=3D"#990000">CustomerName</font></span></span><span class=3Dm1><font color=3Dblue>></font></span><span class=3Dtx1><b> = CORPORATION</b></span><span class=3Dm1><font color=3Dblue></</font></span><span = class=3DSpellE><span class=3Dt1><font color=3D"#990000">CustomerName</font></span></span><span = class=3Dm1><font color=3Dblue>></font></span> <o:p></o:p></span></font></p> <p class=3DMsoNormal style=3D'text-indent:-24.0pt'><span = class=3Db1><b><font size=3D2 color=3Dred face=3D"Courier New"><span = style=3D'font-size:10.0pt'> </span></font></b></span><font size=3D2 face=3DVerdana><span = style=3D'font-size:10.0pt;font-family:Verdana'> <span class=3Dm1><font color=3Dblue><<span style=3D'mso-tab-count:1'>=A0 = </span><</font></span><span class=3Dt1><font color=3D"#990000">SBU</font></span><span = class=3Dm1><font color=3Dblue>></font></span><span class=3Dtx1><b>F</b></span><span = class=3Dm1><font color=3Dblue></</font></span><span class=3Dt1><font = color=3D"#990000">SBU</font></span><span class=3Dm1><font color=3Dblue>></font></span> = <o:p></o:p></span></font></p> <p class=3DMsoNormal style=3D'text-indent:-24.0pt'><span = class=3Db1><b><font size=3D2 color=3Dred face=3D"Courier New"><span = style=3D'font-size:10.0pt'> </span></font></b></span><font size=3D2 face=3DVerdana><span = style=3D'font-size:10.0pt;font-family:Verdana'> <span class=3Dm1><font color=3Dblue><<span style=3D'mso-tab-count:1'>=A0 = </span><</font></span><span class=3DSpellE><span class=3Dt1><font = color=3D"#990000">OrderNumber</font></span></span><span class=3Dm1><font color=3Dblue>></font></span><span = class=3Dtx1><b>12345</b></span><span class=3Dm1><font color=3Dblue></</font></span><span = class=3DSpellE><span class=3Dt1><font color=3D"#990000">OrderNumber</font></span></span><span = class=3Dm1><font color=3Dblue>></font></span> <o:p></o:p></span></font></p> <p class=3DMsoNormal style=3D'text-indent:-24.0pt'><span = class=3Db1><b><font size=3D2 color=3Dred face=3D"Courier New"><span = style=3D'font-size:10.0pt'> </span></font></b></span><font size=3D2 face=3DVerdana><span = style=3D'font-size:10.0pt;font-family:Verdana'> <span class=3Dm1><font color=3Dblue><<span style=3D'mso-tab-count:1'>=A0 = </span><</font></span><span class=3DSpellE><span class=3Dt1><font color=3D"#990000">ItemNumber</font= ></span></span><span class=3Dm1><font color=3Dblue>></font></span><span = class=3Dtx1><b>12345</b></span><span class=3Dm1><font color=3Dblue></</font></span><span = class=3DSpellE><span class=3Dt1><font color=3D"#990000">ItemNumber</font></span></span><span class=3Dm1><font = color=3Dblue>></font></span> <o:p></o:p></span></font></p> <p class=3DMsoNormal style=3D'text-indent:-24.0pt'><span = class=3Db1><b><font size=3D2 color=3Dred face=3D"Courier New"><span = style=3D'font-size:10.0pt'> </span></font></b></span><font size=3D2 face=3DVerdana><span = style=3D'font-size:10.0pt;font-family:Verdana'> <span class=3Dm1><font color=3Dblue><<span style=3D'mso-tab-count:1'>=A0 = </span><</font></span><span class=3DSpellE><span class=3Dt1><font = color=3D"#990000">ItemDesc</font></span></span><span class=3Dm1><font color=3Dblue>></font></span><span = class=3Dtx1><b>Test</b></span><span class=3Dm1><font color=3Dblue></</font></span><span = class=3DSpellE><span class=3Dt1><font color=3D"#990000">ItemDesc</font></span></span><span class=3Dm1><font = color=3Dblue>></font></span> <o:p></o:p></span></font></p> <p class=3DMsoNormal style=3D'text-indent:-24.0pt'><span = class=3Db1><b><font size=3D2 color=3Dred face=3D"Courier New"><span = style=3D'font-size:10.0pt'> </span></font></b></span><font size=3D2 face=3DVerdana><span = style=3D'font-size:10.0pt;font-family:Verdana'> <span class=3Dm1><font color=3Dblue><<span style=3D'mso-tab-count:1'>=A0 = </span><</font></span><span class=3Dt1><font color=3D"#990000">LOD</font></span><span = class=3Dm1><font color=3Dblue>></font></span></span></font><st1:date Month=3D"12" = Day=3D"12" Year=3D"2002"><span class=3Dtx1><b><font size=3D2 face=3DVerdana><span = style=3D'font-size:10.0pt;font-family:Verdana'>12/12/02</span></font></b= ></span></st1:date><span class=3Dm1><font size=3D2 color=3Dblue face=3DVerdana><span = style=3D'font-size:10.0pt; font-family:Verdana'></</span></font></span><span class=3Dt1><font = size=3D2 color=3D"#990000" face=3DVerdana><span = style=3D'font-size:10.0pt;font-family:Verdana'>LOD</span></font></span><= span class=3Dm1><font size=3D2 color=3Dblue face=3DVerdana><span = style=3D'font-size:10.0pt; font-family:Verdana'>></span></font></span><font size=3D2 = face=3DVerdana><span style=3D'font-size:10.0pt;font-family:Verdana'> = <o:p></o:p></span></font></p> <p class=3DMsoNormal style=3D'text-indent:-24.0pt'><span = class=3Db1><b><font size=3D2 color=3Dred face=3D"Courier New"><span = style=3D'font-size:10.0pt'> </span></font></b></span><font size=3D2 face=3DVerdana><span = style=3D'font-size:10.0pt;font-family:Verdana'> <span class=3Dm1><font color=3Dblue><<span style=3D'mso-tab-count:1'>=A0 = </span><</font></span><span class=3DSpellE><span class=3Dt1><font = color=3D"#990000">PreInc</font></span></span><span class=3Dm1><font color=3Dblue>></font></span><span = class=3Dtx1><b>35.17</b></span><span class=3Dm1><font color=3Dblue></</font></span><span = class=3DSpellE><span class=3Dt1><font color=3D"#990000">PreInc</font></span></span><span class=3Dm1><font = color=3Dblue>></font></span> <o:p></o:p></span></font></p> <p class=3DMsoNormal style=3D'text-indent:-24.0pt'><span = class=3Db1><b><font size=3D2 color=3Dred face=3D"Courier New"><span = style=3D'font-size:10.0pt'> </span></font></b></span><font size=3D2 face=3DVerdana><span = style=3D'font-size:10.0pt;font-family:Verdana'> <span class=3Dm1><font color=3Dblue><<span style=3D'mso-tab-count:1'>=A0 = </span><</font></span><span class=3DSpellE><span class=3Dt1><font = color=3D"#990000">PostInc</font></span></span><span class=3Dm1><font color=3Dblue>></font></span><span = class=3Dtx1><b>37.37</b></span><span class=3Dm1><font color=3Dblue></</font></span><span = class=3DSpellE><span class=3Dt1><font color=3D"#990000">PostInc</font></span></span><span class=3Dm1><font = color=3Dblue>></font></span> <o:p></o:p></span></font></p> <p class=3DMsoNormal style=3D'text-indent:-24.0pt'><span = class=3Db1><b><font size=3D2 color=3Dred face=3D"Courier New"><span = style=3D'font-size:10.0pt'> </span></font></b></span><font size=3D2 face=3DVerdana><span = style=3D'font-size:10.0pt;font-family:Verdana'> <span class=3Dm1><font color=3Dblue><<span style=3D'mso-tab-count:1'>=A0 = </span><</font></span><span class=3DSpellE><span class=3Dt1><font = color=3D"#990000">ChangeAmount</font></span></span><span class=3Dm1><font color=3Dblue>></font></span><span = class=3Dtx1><b>2.20</b></span><span class=3Dm1><font color=3Dblue></</font></span><span = class=3DSpellE><span class=3Dt1><font color=3D"#990000">ChangeAmount</font></span></span><span = class=3Dm1><font color=3Dblue>></font></span> <o:p></o:p></span></font></p> <p class=3DMsoNormal style=3D'text-indent:-24.0pt'><span = class=3Db1><b><font size=3D2 color=3Dred face=3D"Courier New"><span = style=3D'font-size:10.0pt'> </span></font></b></span><font size=3D2 face=3DVerdana><span = style=3D'font-size:10.0pt;font-family:Verdana'> <span class=3Dm1><font color=3Dblue><<span style=3D'mso-tab-count:1'>=A0 = </span><</font></span><span class=3DSpellE><span class=3Dt1><font = color=3D"#990000">ChangePercentage</font></span></span><span class=3Dm1><font color=3Dblue>></font></span><span = class=3DGramE><span class=3Dtx1><b>6.26%</b></span></span><span class=3Dm1><font color=3Dblue></</font></span><span = class=3DSpellE><span class=3Dt1><font color=3D"#990000">ChangePercentage</font></span></span><span = class=3Dm1><font color=3Dblue>></font></span> <o:p></o:p></span></font></p> <p class=3DMsoNormal style=3D'text-indent:-12.0pt'><span = class=3Db1><b><font size=3D2 color=3Dred face=3D"Courier New"><span = style=3D'font-size:10.0pt'> </span></font></b></span><span class=3Dm1><font size=3D2 color=3Dblue face=3DVerdana><span = style=3D'font-size:10.0pt; font-family:Verdana'></</span></font></span><span class=3Dt1><font = size=3D2 color=3D"#990000" face=3DVerdana><span = style=3D'font-size:10.0pt;font-family:Verdana'>Customer</span></font></s= pan><span class=3Dm1><font size=3D2 color=3Dblue face=3DVerdana><span = style=3D'font-size:10.0pt; font-family:Verdana'>></span></font></span><font size=3D2 = face=3DVerdana><span style=3D'font-size:10.0pt;font-family:Verdana'><o:p></o:p></span></font>= </p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt; font-family:Arial'>There are 4 different <span = class=3DSpellE>SBU's</span> and I want to sub-total at the end of each SBU.<span = style=3D'mso-spacerun:yes'>=A0 </span>How can I do this?<o:p></o:p></span></font></p> </div> </body> </html> ------_=_NextPart_001_01C30421.C57B7460--