• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Nesting Subtotals

If the existing subtotal groups don't show enough detail, you can insert a subtotal within a subtotal group (this is called nesting subtotals). Follow the steps in this procedure:

1.
Choose Data, Subtotals to display the Subtotal dialog box.

2.
In the At Each Change In list box, select the field you want to use for the new subtotal grouping.

3.
Enter any other options you want to use for the new subtotal.

4.
Deactivate the Replace Current Subtotals check box.

5.
Click OK. Excel calculates the new subtotals and adds them to the list.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint