I have a report that includes a date field (Invoice Due Date). I need to group these records by month & year. The SubSummary is set to show when sorted by due date and the script sorts by due date. However, it groups the records by the actual date rather than by month, which is what I need.
If I made calculated fields to return Month and Year I could sort by those but the subsummary only shows when sorted by one field.
I'm sure I'm missing something obvious but how do I get this working?
Thanks in advance.