The Advanced Table Viewer
| Status | ||||
|---|---|---|---|---|
|
Beta release: In the beta release, the summarize (Sum-up) option enables you to display the sum (SUM) or average (AVG) for column values containing only numeric data.
...
Automatically calculate and display the sum (Sum) or average (Avg) for columns containing numeric data.
Sum-up (
) is available in both the Edit and View mode of the macro on the Confluence page.When the Sum-up row is added, the Sum value is displayed by default for the numeric columns. For columns containing both numeric and non-numeric data or only non-numeric data, the Sum-up values will remain empty.
The Sum-up type configuration defined in the macro's page edit mode is saved as the default for each column and will automatically apply with each Confluence page refresh.
...
To include the Sum-up row, click the Sum-up icon (
) in the right corner just above the table.
The Sum-up row is included as the first row of the table, just below the table header row, and is preceded by an
icon. 
Additionally, the column properties ellipsis (
) is displayed for each column.
You can see that the SUM Sum value is displayed by default for all numeric columns except the non-numeric columns.
You have options to Using the column properties option, you can change the Sum-up type between to Sum, Avg, and None.
Sum: Calculates the total of all values in the column.
Avg: Calculates the average of all values in the column.
Option 1: Change the Sum-up type using the Edit column dialog
To display the average value change the Sum-up type for any specific column, click the column setting ellipsis properties (
). For reference, to display the average value for the Tax column, click the ellipsis.
The ellipsis menu column properties ( ) option for each column becomes active, enabling the Edit column dialog box to open is enabled only after the Sum-Up up row is inserted.
The Edit column dialog opens. Click the Sum-up type drop-down and select the required type. For reference, Avg is selected.
The Tax column displays the average (Avg) value. Likewise, you can choose the Sum-up type for each column as required.
Option 2: Switch between the Sum-up type with clicks
Quickly switch the Sum-up type with a sequence of clicks on the specific column header Sum-up value without opening the Edit column dialog. Each click changes the displayed values between Sum, Average, and None.
The Sum value is displayed by default.
Click the Tax column header Sum-up value, and the column will display the Avg value.
...