Pivot Tip 1 - First step, remove those subtotals. By David Carter
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.