Hi, I had posted a message under this forum with title Retrieving All Customer element with ids contained in a list.
With the suggestions of Xpath, I was able to acheive most of what I wanted. But there is one more glitch that I’m not able to resolve. I have two elements partner and customer. There are 4 levels for a partner and each customer will be the last level which is level 4 and associated with a person on level 3 (District) which in turn will be associated with a level 2 (Region). The corporate level is the top level. I have partner element with in which the relationship between the region and branches are listed. For each branch, I have a customer element which will be a sibling to the partner element. There will be number of transactions for each customer element.
I’m able to select all customers under specific district. I’m having trouble with selecting all customers under different districts, but those districts belonging to one region. When I have only one district in each region, it works perfectly. If I have two districts in the same region, it ignores the second district and gives the summary of only one district. I’m attaching a result doc that has the result when I have one district under each region and also when I have two districts under the same region. The result should have been a sum of both districts and displayed in the table row. I’m also attaching all my XSL files and XML file that I’m using. I’d really appreciate any help or suggestions made and it’d save my day.
XML-XSLFiles.zip (83.7 KB)