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.
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.
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, 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.