I have only been using XSL for the past few months and am having trouble
trying to group certain elements or attributes together while at the same
time summing up their values. Here is a sample of the XML that we are
using:
<cmsParent xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
parentShortDesc="FIN_INFO_SERVICES" parentLongDesc="Financial Information
Services">
<node nodeShortDesc="001010" nodeLongDesc="Annual Meeting" partitionKey
="CST200304200304A001ECORP" costDom="ECORP" from_dt="2003-04-01" adjdate=""
adjindic="N">
<actv actvShortDesc="PERFORM STRAT INIT" actvLongDesc="Perform
Strategic Initiatives">
<dimensions>
<prod prodShortDesc="xyz" prodLongDesc="XYZ Corporation" />
<cust prodShortDesc="abc" prodLongDesc="ABC Corporation" />
<chan prodShortDesc="zzz" prodLongDesc="ZZZ Corporation" />
<comp prodShortDesc="003" prodLongDesc="Nationwide Property" />
<mthCost>500.00</mthCost>
<ytdCost>1000.00</ytdCost>
</dimensions>
<dimensions>
<prod prodShortDesc="xyz" prodLongDesc="XYZ Corporation" />
<cust prodShortDesc="abc" prodLongDesc="ABC Corporation" />
<chan prodShortDesc="zzz" prodLongDesc="ZZZ Corporation" />
<comp prodShortDesc="002" prodLongDesc="Nationwide Life" />
<mthCost>1000.00</mthCost>
<ytdCost>2000.00</ytdCost>
</dimensions>
</actv>
</node>
</cmsParent>
The output needs to look like this:
actvShortDesc: Perform Strategic Initiatives
Product Current Month Year to Date
XYZ Corporation 1500.00 3000.00
Customer Current Month Year to Date
ABC Corporation 1500.00 3000.00
Channel Current Month Year to Date
ZZZ Corporation 1500.00 3000.00
Company Current Month Year to Date
Nationwide Property 500.00 1000.00
Nationwide Life 1000.00 2000.00
Any help would be much appreciated on this topic.
Thanks, Todd Gordish
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list