I am struggling to create a report. I have attached a chart to show what I am trying to do.
Any help will stop be going mad.
I am struggling to create a report. I have attached a chart to show what I am trying to do.
Any help will stop be going mad.
Ah the bottom N then ...!
Have a look at this page: http://allenbrowne.com/subquery-01.html.
In particular the top n records per group but you need to sort in ascending order