Is it possible to export a report by "Order Number'
So it is showing the above data based on customers, over a 1 month time period, or one week or fortnigh?
To get the information you're looking for above in one single report, I think you would be best off doing an order export.
This can be done by going to Orders in your admin and exporting them at the top right. Once you've exported them into a spreadsheet, you can delete columns you don't need or even apply filters if you want to see the information prioritized differently.
We have just released the Orders Export for the Bulk Import Export Update with Excel app.
While in Beta testing, it will export you all the Orders data in the Free plan too, so feel free to try out - we have specifically tailored it to be usable in Excel Pivot tables too.
Here is the video of its current capabilities and fields: Shopify Orders Export.
This is the right moment to ask for specific things to be included.
You can export the fields that you require automatically using Data Export.
You can run the reports by date (daily, hourly, monthly) or by Order number (from order number to order number).
Please contact me if you have any questions.