Drag a column header into the group panel to group rows (for example by order, date, or collection). Use the filter row as usual. Export to Excel from the toolbar.