Summarize numeric column values with Advanced Table Viewer macro [Beta] - cloud

The Advanced Table Viewer BETA macro provides the summarize (Sum-up) option for numeric column values on the Confluence page, allowing you to perform calculations efficiently on numeric columns.

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.

Sum-up overview

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 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 page edit mode is saved as the default for each column and will automatically apply with each Confluence page refresh.

Configure the Sum-up row

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 value is displayed by default for all numeric columns except the non-numeric columns.
Using the column properties option, you can change the Sum-up type 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 change the Sum-up type for any specific column, click the column properties ( ). For reference, to display the average value for the Tax column, click the ellipsis.

The column properties ( ) option for each column is enabled only after the Sum-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 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 Sum-up value, and the column will display the Avg value.