» Show/Hide Subtotals in Excel 2007
CATEGORY - Excel Pivot Tables
VERSION - Microsoft Excel 2007
Select PivotTable Tools Ribbon-> Design tab -> Subtotals (in Layout Group).
To Select the Subtotal function(s):
1. Drag at least two fields to the Row Labels.
2. Select a cell in the first Row Label field, right click and select Field Settings -> Subtotals & Filters tab.
Under Subtotals section in Field Settings dialog box there are three option buttons:
Automatic: Excel uses the SUM formula as default when inserting subtotals.
Custom: Select this option to insert one or more functions.
None: Displays the PivotTable report without subtotals.
Book Store:
Recommended Books:
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- Dictionary of Finance and Investment Terms
- Excel 2002 For Dummies®
- Microsoft Excel VBA Programming for the Absolute Beginner
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- Windows XP All-in-One Desk Reference For Dummies
No comments have been submitted.
