Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

    Sum_up_icon.jpg
  • The Sum-up row is included as the first row of the table, just below the table header row, and is preceded by an Sum-up sign.jpg icon.

    Sum_up_row_added.jpg
  • 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 (ellipsis.jpg ). For reference, to display the average value for the Tax column, click the ellipsis.

  • (blue star) The ellipsis menu for each column becomes active, enabling the Edit column dialog box to open only after the Sum-Up row is inserted.

    Sum_up_row.jpg
  • The Edit column dialog opens. Click the Sum-up type drop-down and select the required type. For reference, Avg is selected.

    Edit column_change_sum_type.jpg
  • The Tax column displays the Avg value. Likewise, you can choose the Sum-up type for each column as required.

    Sum_up_AVG.jpg

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.

...