Navigate to Store Earnings & Reports > Orders Report
Use the date and location filters to select the time period and store you wish to generate a report for and hit Apply.
Once those dates are applied. Click on the Summary button underneath the Select Date filters. This will generate an itemised report along with the quantity sold of each item and the revenue generated.
You can Export this into a .CSV file that can be opened with Microsoft Excel or Numbers.