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

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 group (other formulas are also available).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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