Define the aggregation to be applied to the column as a total. Note: the calculated total is only available for calculated fields and will create a total based on the same rules as were used for the calculation. For example if you have a ratio of Received / Invoiced the total will equal the Sum (Received) / Sum (Invoiced)
Display Total Value
Show or hide the total aggregated value of a column. Note that this does not affect subtotals, i.e. if you’ve chosen to hide the total, the subtotals will still be displayed. Works for regular and cross-tab reports.
Move Total Value Location
When Display Total Value is activated, choose whether to display the table totals at their default location of the end of the table, or activate this option to move the totals to the start of the table.
Display Labels
Display a text label for the column summary.
Style
Define custom formatting for the summaries of this column. This covers the font facetypeface, font size, font colour and emphasis, font style, and text alignment.
Background
Define the background colour for the column summary.
Sub Total
Display a sub total row for each unique value in the column.
Move Sub Total Value Location
When Sub Total is activated, choose whether to display the table subtotals at their default location of the end of each section, or activate this option to move the subtotals to the start of the each section.
Hide Sub Total on Columns
Select column fields from this list to hide their subtotal. Works for regular and cross-tab reports.
Tip: Remember to disable conditional formatting on subtotal cells if you’re opting to hide the subtotal values.