Overview
- Field Totals
- Categorical Sub Totals
- Section Totals
- Section Summary Tables
- Grand Totals
Depending on the type of summary you are creating, you will have access to a selection of the following types:
Symbol | Summary type | Description |
---|---|---|
Sum | This will add all of the values in the field to create the total. | |
Average | This will find the mean value of all the values in the field to create the total. | |
Count | This will count the number of values in the field to create the total. | |
Count Distinct | This will count the number of unique values in the field to create the total. | |
Calculated Total | This is only available if the field is a calculation, and uses the calculation to create the total. Note: To display the total of a calculated field, ensure that each individual field included in the calculation formula:
|
Standard Table Summaries
Total Aggregation
Display Labels
Style
Sub Total
Section Summaries
Section Summary
Section Total & Labels
Grand Totals
Cross Tab Summaries
Column Totals
Row Totals
Sub-Totals
Sub-totals work on multiple levels in cross-tabs reports. You can calculate row totals across columns, and column totals across rows. You can even get totals of column totals and row totals. This is also done at the grand total level; that is, a total of two separate sections can be done across rows and columns. Refer to the example screenshots.