I need a matrix for 2 groups (Department - ‘Nursing’ and ‘Other’) What I am doing is showing the Days/Hours they worked for the time frame they select. If they fall into the Nursing Group I need the hours Grouped into 3 shifts but if they fall into the ‘Other’ group the hours are grouped by the day only. Each group needs subtotals and I need a grand total for both Groups.
I also need 2 empty rows after each Group subtotal which will be used for calculations once the report is exported to Excel.
Please see attached spreadsheet.