Well, you know we don't write code for people here. But it seems to me that grouping wouldn't be a bad approach. Sorting based on the "Amount" element and choosing the last value out of the sort would also work.
Joined: Sep 24, 2008
Thanks for the reply. Actually your reply induced me to do some research on this and finally I got my output. :)
That's not bad at all. Grouping isn't an easy thing to do in XSLT 1.0, but it looks like you have it working.
I learned XSLT by reading Michael Kay's book. But there are tutorials on the web, some good, some bad. I don't recommend the ones at w3schools because they just rehash the syntax. That means they don't mention important concepts which aren't described by syntax, like the built-in template rule for example. And they choose examples designed to explain the specific elements of syntax, which isn't the right way to choose examples.
(It's like help documents which answer questions like "What does the F7 key do" when your question is more like "How do I get to the next customer record".)