A customer has been trying to create a report which showed the total sales value & total quantity sold within a particular period for each of their products. They have been able to create a report using sales transaction but this shows individual lines for each order when really they just want one line for each product showing the total sales value & total quantity sold. You can use grouping to show this summary information but ideally they would like to export this summary information to excel.
