Advanced Spreadsheets – Sub-totaling

Use automatic sub-totaling features.

Automatic sub-totaling features help in displaying the sub-totals of particular sections of a table. To use automatic sub-totaling features, first of all make sure that you have automatic filters enabled for all the columns for which sub-totaling needs to be done. After this, select any one cell from the entire range.


img126
img127
img128
img129
img130
img131
img132
img133
img134
img135
img136
img137
img138
img139


Subtotal 18

Now click on ‘Data’ from the main menu bar and from the resulting drop-down, click on ‘Subtotals’. This will open the ‘Subtotals’ dialog box.
export Subtotal 19
In this dialog box, we have some tabs which give the option for creating three groups and in each of these tabs we have some options. In the ‘Group by’ drop down list, we can select the field by which we want to group the data, and then we can select the fields whose subtotal needs to be calculated. We can choose from a list of functions for calculating the subtotals. After making all the changes, click on ‘OK’. The subtotal calculation and grouping for the data will get done.
Expand Subtotals

Expand, collapse outline detail levels.

To expand or collapse the outline detail levels, you can simply use the ‘+’ and ‘-’ signs produced at the leftmost side of the data table upon the generation of subtotals. Upon clicking the ‘-’ sign, the detail level will collapse and on clicking the ‘+’ sign the detail level will expand back.
Colapse Subtotal 21