» Adding Subtotals to Primary and Secondary Fields
CATEGORY - Excel Subtotals
VERSION - All Microsoft Excel Versions
To add subtotals to primary and secondary fields:1. Sort, in ascending order, the field for which you want to have the secondary subtotal. In this example (see screenshot), Customer Name is the secondary field.
2. Sort, in ascending order, the field for which you want to have the primary subtotal. In this example (see screenshot), Market is the primary field.
3. Click the Subtotals box.
4. From the At each change in dropdown list, select Market.
5. In Add Subtotal to, select the Quantity and Income checkboxes.
6. Deselect the Replace current subtotals checkbox, and then click OK.
7. Repeat steps 3 and 4, and select Customer Name.
8. Click OK.

Book Store:
Recommended Books:
- Microsoft Office XP Introductory Concepts and Techniques
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- Microsoft Access Version 2002 Step by Step
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
No comments have been submitted.

