Ok, I popped the results into a temporary table. It's only giving the results (rn = 1) for either the first or the last year (depending on whether I remove the desk or not) ie. a total of 12 results

This is a little like I got stuck before, I want something like month(date)&year(date) to partition on :ermm: