IBM Lotus Symphony


Grouping Ranges and Calculating Subtotals

If you want to expand the sample data and in order to use it, you will also want to summarize and print the data in totals and subtotals. This can be done in just a few steps:

  1. Place the cursor in the range.
  2. Choose Data - Subtotals. The Subtotals dialog appears.
  3. Specify the options for calculating the subtotals:
    • In Group by box, select the column that you want to use to control the subtotal calculation process.
    • In Calculate subtotals for field, select the column(s) containing the values that you want to subtotal.
    • In Use function field, select the mathematical function that you want to use to calculate the subtotals. You have to assign function to each selected column individually.

    For example, group by "Date" (a subtotal is calculated for each new date), and calculate subtotals for "Amount" using the function "Sum" (adds the subtotals).

Subtotals options

As soon as you press Enter or click OK, the range will be grouped with subtotals. For every group of rows with an identical date, a subtotal is calculated. The grand total is displayed at the bottom.

Show Subtotals

Notice the controls to the left of the row headers. They enable you to view which records (rows) have been summarized. If you click on a minus sign, only the row with the results is shown. The easiest way to control the display is with the small digits above the group area. If you click on 1, only the grand total is displayed; 2 reveals the subtotals, and 3 shows all elements.


Product Feedback | Additional Documentation | Trademarks