» 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:
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- Marketing Plans That Work, Targeting Growth and Profitability
No comments have been submitted.
