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. From the pivot table menu, select 'Group and Show Details', then 'Group'.
To practise this tip, open up the Excel file Pivot_Practice.xls.
First, create the following pivot table:
ROW = ACC, CUSTNAME
DATA = NET
Remove any subtotals from ACC
Note: If you are unsure how to do this, the first article in the series...