A script-enabled browser is required for this page to function properly.

Creating a summary column

To create a summary column (for totals or subtotals) using the Data Wizard:

  1. In the Data Model view, click the query that contains the column you want to total.

  2. Choose Toolsright arrowData Wizard.

  3. On the Totals page, follow the wizard to add the desired summary to your report.  

Note: For group reports, the Report Wizard and Data Wizard create n summary fields in the data model for each summary column you define: one at each group level above the column being summarized, and one at the report level.   For example, if a report is grouped by division, and further grouped by department, then a summary column defined for a salary total would create fields for the sum of salaries for each division and each department group (group-level summaries), and the sum of all salaries (report-level summary).

To create a summary column (for totals or subtotals) using the tool palette:

  1. In the Data Model view, single-click the Summary Column tool in the tool palette, then:

  2. Double-click the summary column object to display the Property Inspector.

  3. Under the Summary node:

Usage notes

See also

About summary columns

Reset At property

Creating or editing a placeholder column

Creating or editing a formula column