You can use the Group and Summarise section within our data grid reports to group certain fields together.
To do this, find the data grid report you would like to run and once inside the report, select the Group and Summarise option.
Choose the fields you would like to group together and the function you would like to select and then click on the spreadsheet icon in the bottom right corner.
