Add sums to your report

Adding sums to a report

In addition to grouping and sorting, you can add subtotals, grand totals, and other calculations to your reports. For example, you can calculate how much you spent on a given model of desk or office chair.

With your report still open in Layout view, start the Group, Sort, and Total pane, click a grouping level, and then click More.

Locate the “totaled” field and click the arrow next to it.

Use the Totals dialog box to select the field you want to calculate, the type of calculation you want to use, such as a sum or average, and to set options such as subtotals and grand totals.

When you finish, your report displays the calculations.

Topic 5 of 10

Previous | Next

(Back to Start)

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!