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