Depending on the type of summary you are creating, you will have access to a selection of the following types:
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
|
|
|
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:
|
|
|
|
|
|