David Carter's Five Minute Tips are designed to help you develop your Excel pivot table skills. If you want to test the tip for yourself, David has included a brief worked example on the pivot practice database.
Pivot Tip #1 - How to remove subtotals quickly
When you create a pivot table with more than one item in the Row area, Excel will automatically create subtotals. Most of the time they get in the way and you want to remove them. To do this quickly:
Double left-click the mouse on the grey Field button of the field being subtotalled. In the Pivot Table Field box, change Subtotals from Automatic to None.
To practise this tip, open up the Excel file Pivot_Practice.xls. (There are only 27 records in this file. It should be quite easy to...