Hi, I have a big orders spreadsheet with numerous columns, including order date in dd/mm/yy format, covering the entire year's worth of orders. I want to create a report to show on average how many orders we receive on particular days of the week. What I'm trying to identify are the busiest day(s) and the quieter day(s) based on Mon-Fri, with a view to using that as part of a case for additional resource. How can I run a pivot table which sees the order dates as Mon, Tue, Wed, etc., adds up all the Mondays, Tuesdays, etc. from the year, and shows an average number of daily orders (a count of entries) for each day? So eventually I would like to see a bar graph showing only 5 days of the week along the x axis and the average number of orders in the y axis.
Bookmarks