Conditionally showing a record

[Mike Urban <murban@xxxxxxxxxxxxx>]

Here is an example (simplified version) of my XML docuemnt. 
 

<Example>

    <Record>

        <Order>

            <Line>10</Line>

            <Item>100</Item>

            <Price>10.00</Price>

        </Order>

    </Record>

    <Record>

        <Order>

            <Line>11</Line>

            <Item>200</Item>

            <Price>20.00</Price>

        </Order>

    </Record>

    <Record>

        <Order>

            <Line>20</Line>

            <Item>300</Item>

            <Price>30.00</Price>

        </Order>

    </Record>

    <Record>

        <Order>

            <Line>22</Line>

            <Item>400</Item>

            <Price>40.00</Price>

        </Order>

    </Record>

</Example>

 

In my XSL I want to only show the Records when the element Line is evenly divisiable by 10.  So, my ending result would be.

 

Line        Item       Price

10          100        $10.00

20          300        $30.00

 

Total                  $40.00

 

Then I would like to tale the lines that wer not divisiable by 10 and combine them into one line with a total on the element Price.

 

Other Total            $60.00

 

 

Thank you in advance for any assistance.

 

Mike Urban

murban@xxxxxxxxxxxxx