xsl-list
[Top] [All Lists]

grouping and sum

2004-12-06 07:38:23
how is it possible to group by the Customer Node to retrieve a sum from 
StepCharge?


<Portfilio>
<AsOf>11/01/2004</AsOf>
        <Trade>
                <TradeId>ED.TEST</TradeId>      
                <Customer>ABC</Customer>                
                <Step>
                   <MinFlowDate>11/30/2004</MinFlowDate>
                   <StepCharge>4</StepCharge>
                </Step>
                <Step>
                   <MinFlowDate>11/30/2005</MinFlowDate>
                   <StepCharge>6</StepCharge>
                </Step>
        </Trade>
        <Trade>
                <TradeId>ED.TESTFX1</TradeId>
                <Customer>AAA</Customer>        
                <Step>
                   <MinFlowDate>12/11/2004</MinFlowDate>
                   <StepCharge>3</StepCharge>
                </Step>
                <Step>
                   <MinFlowDate>12/11/2004</MinFlowDate>
                   <StepCharge>61</StepCharge>
                </Step>         
                <Step>
                   <MinFlowDate>12/11/2005</MinFlowDate>
                   <StepCharge>11</StepCharge>
                </Step>
        </Trade>        
               <Trade>
                <TradeId>ED.TESTFX1</TradeId>
                <Customer>AAA</Customer>        
                <Step>
                   <MinFlowDate>12/11/2004</MinFlowDate>
                   <StepCharge>3</StepCharge>
                </Step>
                <Step>
                   <MinFlowDate>12/11/2004</MinFlowDate>
                   <StepCharge>61</StepCharge>
                </Step>         
                <Step>
                   <MinFlowDate>12/11/2005</MinFlowDate>
                   <StepCharge>11</StepCharge>
                </Step>
        </Trade>        

</Portfilio>




--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--



<Prev in Thread] Current Thread [Next in Thread>