Displaying Subtotals in Reports
Subtotals can be displayed on printable report formats. The formats include Adobe PDF, Printable Excel, and Printable HTML. Subtotals appear beneath each column selected for display. Subtotals show the sum, maximum, minimum, or average of numeric data. Video: Using Subtotals (1.5 min) is available. The subtotal page can turn on or off two options. One option shows the total number of records per group. The other option shows the grand total at the bottom. Subtotals can be shown for numeric columns such as Total Payments and Balance Due for Registration reports. Subtotals can also show the number of attendees on a Registration Agenda report. To show subtotals for a data field, select Sum, Maximum, Minimum, or Average. Subtotals appear in a row beneath each grouping, or at the bottom if no groupings exist. Note: Groups and Subtotals are ignored when running a Changes Report with the Return Changes Since option. If the report setup includes Groups or Subtotals, Subtotals are not included and Groups are treated as columns in front of the record set, and ignored in the results rendering. This behavior is the same as when a report with Groups or Subtotals is displayed in the Report Results window, since these options are intended for exported report results. Note: Help topics may include features to be released.
Related articles: Report Subtotals