Pivot Tip 2 - How to analyse sales by month. By David Carter
David Carter's series of 'Five Minute tips' aims to develop your skill at using Excel pivot tables. If you want to test the tip for yourself, he takes you through a worked example on the 'pivot practice' database.
When you create a pivot table report in Excel, you will usually want to summarise the report totals by week or month. Use the Group and Show Details command for this.
Right click the mouse on the 'Date' field button in B3.