StarOffice™ 5.2 Calc Handbook

Working with Subtotals

Subtotals allow you to group the data in a database using a particular field and then calculate a subtotal for the field data found in each group. For example, you may have an employee database that lists the department that each employee belongs to (in a Department field) and each employee's salary (in a Salary field). You can use the Subtotal feature to group the data by department and compute a subtotal of the salaries for each department.

When you work with the Subtotal feature, you are not limited to just subtotals (which makes the name of this feature a little misleading). You can actually choose from a range of formulas. You can compute the minimum, maximum, or count the number of entries in a particular subtotal ...