» 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:
- Marketing Planning for Services
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- The One Page Business Plan: Start With a Vision, Build a Company!
No comments have been submitted.

