I have a DVWP that I need to set up a complex filter on.
It WAS all set - grouped by category field, sorted by item title, then filtered on 2 other fields (year & quarter). Then I was given another requirement - that there might be multiple items per the same year and quarter, and I need to display only the most "recent". I can't make the assumption that the users are actually going to create them in order, so I'll need to use the extra "month" field (numeric, 1-12, sometimes null where appropriate).
Is there a way to say "Display all of the items for this year+quarter combination, but sort additionally by the Month field and leave out any duplicates"?
I should note that the month field would not actually be displayed on this DVWP.