The Advanced Table Viewer macro provides the summarize option for numeric column values on the Confluence page, allowing you to perform calculations efficiently on numeric columns.
Beta version: The Beta release enables you to display the total (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 of the macro on the Confluence page.When the Sum-up row is added, the Sum (total) 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 edit mode is saved as the default for each column and will automatically apply with each Confluence page refresh.
How to configure the Sum-up row
To include the Sum-up row, click the Sum-up icon (
) in the right corner just above the table.
Sum-up row
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. You can see that the SUM value is displayed by default for all numeric columns except the non-numeric columns.
You have options to change the Sum_up type between Sum, Avg and None.
Option 1: Change the Sum_up type using the Edit column dialog
To display the average value for any specific column, click the ellipsis (
). For reference, to display the average value for the Tax column, click the ellipsis.
The ellipsis menu for each column becomes active, enabling the Edit column dialog box to open 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 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 series of clicks on the specific column header 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, and the column will display the Avg value.
