Section 26. The Complete View: Aggregate Functions for Automatic Reporting
Add a new sheet called "Auto Analysis."
This sheet will let you specify a year and month, and automatically calculate totals for only that period. Add input cells for Year and Month — leave one blank row at the top, then start building the summary table below.
The table will have countries in rows and weekdays in columns. Go to the Sales sheet, right-click the Item column, choose "Select Column Data," copy it, and paste