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.

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.

Configure the Sum-up row

• To include the Sum-up row, click the Sum-up icon ( ) in the right corner just above the table.

  Open

  

• 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.

  Open

  

• 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 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.