Column group calculation with Advanced Table Viewer macro
The Advanced Table Viewer macro enables you to perform column calculations and display summarized values at each level of the nested group.
Group calculation overview
Group calculation supports the following calculation types: Sum, Average, Minimum, Maximum, Count, and Distinct. For each group, the macro calculates a summarized value from its nested groups and displays it in each grouped row.
To apply group calculation, you must first group the required columns. Refer to Group columns with Advanced Table Viewer macro.
You can configure only one group calculation type for each ungrouped column.
For grouped columns, only column-level calculations apply.
You can configure group calculation only in macro setup mode. You cannot change it in Confluence page view and edit mode.
The macro displays the configured values in the Confluence page view and edit mode.
