» Adding/Deleting Subtotals
CATEGORY - Excel Pivot Tables
VERSION - All Microsoft Excel Versions
To add subtotals to a PivotTable report:1. Drag at least two fields to the Row area that is left of the Data area).
2. Double-click the left Row field's gray title; (see Years gray button in cell A6).
The PivotTable Field dialog box has three option buttons:
• Automatic: Excel uses the SUM formula as the default when inserting subtotals.
• Custom: Selecting this option allows the insertion of one or more formulas.
• None: Displays the PivotTable report without subtotals.
Book Store:
Recommended Books:
- Excel 2002 For Dummies®
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- Special Edition Using Microsoft Office XP
- Yes, You Can Time the Market!
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
No comments have been submitted.
