Microsoft Office Tutorials and References
In Depth Information
Creating a Subtotal Report
Once you’ve sorted your list—let’s go with the
sorting shown in Figure 7-10, at the end of the
multiple-field sort process—follow these steps to
create your Subtotal Report:
3. Click the At Each Change In drop-down
menu, and see a list of all your fields, as
shown in Figure 7-14.
Don’t select your database or any series
of rows within it before beginning this
procedure. To do so risks confusing Excel
as to the beginning and end of your list.
Just click in any cell within the data, and
you’re ready to get started.
Pick the field that represents the first-level grouping
within your sorted list. State is the best choice here.
1. On the Data tab, click the Subtotal button,
shown in the callout in Figure 7-11.
4. Click the Use Function drop-down menu to
choose what calculation you want performed
on the field you’ll choose in the Add Subtotals
To list (see next step). A wide variety of
accounting, statistical, and analytical
functions are offered, as shown in Figure 7-15.
2. In the resulting Subtotal dialog box (shown
in Figure 7-13), you will begin choosing
which fields to subtotal.
Pick your subtotal fields—typically those
you sorted by before starting the report—and
decide which calculation to perform.
Using the Local Population field, choose Average,
to see the average home values in each state.