Setting up Subtotals

If the data you selected includes numerical fields, you can set up the query to perform calculations on the data. Use this procedure to define how you want subtotals and sums displayed in the worksheet.

To display a subtotal

  1. Click the Subtotal tab.
  2. From the At Each Change In list, select the record at which you want Excel to calculate a subtotal.
  3. From the Use Function list, select the operation you want Excel to perform.
  4. In the Add subtotal to: list, select the field you want the calculations to be performed on.
  5. Click Next to proceed to the Sort tab.