Pivot Tip 17 - Use Subtotals to create detailed reports
ExcelZone's Five Minute Tips aim to develop your skill at using Excel pivot tables. To test these formating tips for yourself, try them out on your copy of the pivot_practice.xls database.
Pivot tables are perfect for creating summary (ie totals only) reports. But sometimes managers insist on detailed reports showing individual transactions. For example, sales reps are suspicious characters.