...
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 setting properties ellipsis (
) is displayed for each column.
You can see that the SUM Sum value is displayed by default for all numeric columns except the non-numeric columns.
You have Using the column properties option to , you can change the Sum-up type between 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 display the average value for any specific column, click the column setting ellipsis properties (
). For reference, to display the average value for the Tax column, click the ellipsis.
The column setting properties option for each column is enabled only after the Sum-Up 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.
...