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