Page History
...
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
Styleclass | ||
---|---|---|
| ||
Total Aggregation
Expand | ||
---|---|---|
| ||
There are two methods for adding a total to a field in a standard Column or Row based table: Field Drop Down
Column Formatting menu
|
Display Labels
Expand | ||
---|---|---|
| ||
|
Style
Expand | ||
---|---|---|
| ||
|
Sub Total
Expand | ||
---|---|---|
| ||
Sub Totals are used when there are multiple records per category, possibly caused by having multiple dimension fields in a table, and it would be beneficial to view a total value for each category value. The example shown here could use a sub total for Year, as there are multiple rows per year value due to the Quarter field.
When using Sub Totals, we often pair this functionality with the Suppress Duplicates option, to make the report output easier to consume. To apply this option:
|
...
Section Summaries
Styleclass | ||
---|---|---|
| ||
Section Summary
Expand | ||
---|---|---|
| ||
|
...
horizontalrule |
---|
Styleclass | ||
---|---|---|
| ||