Explanation

To remove existing subtotals:

Data → Subtotal → Remove All

This removes the subtotal calculations and outline structure while keeping the original records.

Important Options

Replace current subtotals

Replaces existing subtotal calculations.

Page break between groups

Adds page breaks between groups when printing.

Summary below data

Places the subtotal below each group.

Example

For a printable sales report, you can enable:

Page break between groups

to separate each city onto different printed pages.

Practice

  1. Create City subtotals.
  2. Add a second subtotal analysis.
  3. Remove all subtotals.
  4. Recreate the report.
  5. Test the Summary below data
PreviousNext