This outline represents the hierarchical structure of your subtotals, and can be used to hide or show data at different levels in the hierarchy using the numbered column indicators at the top of the outline or the group indicators, denoted by plus (+) and minus (-) signs. When you use the Subtotals tool, Calc inserts an outline to the left of the row number column. Calc will add subtotal and grand total rows to your cell range. If you do not want to add more groups, then leave the Group by list for each page set to “- none -”.Ĭlick OK. You can create two more subtotal categories by using the Second Group and Third Group pages and repeating steps 3 to 6. Repeat steps 4 and 5 to create subtotals for other columns on the First Group page.
In the Use function box on the First Group page, select a function to calculate the subtotals for the column selected in step 4. If you later change values in this column, Calc will automatically recalculate the subtotals.
In the Calculate subtotals for box on the First Group page, select a column containing values to be subtotaled. Entries in the cell range from step 1 will be grouped and sorted by matching values in this column. In the Group by drop-down list on the First Group page, select a column by its label.
Alternatively, click on a single cell within your data to allow Calc to automatically identify the range.Ĭhoose Data - Subtotals to open the Subtotals dialog. Select the cell range for the subtotals that you want to calculate, and remember to include the column heading labels. To insert subtotal values into a worksheet:
0 kommentar(er)
