Total

This Analytics Edge wizard is used to create a numeric aggregate row or column, like Total or Average. You can choose to aggregate only the first or last group of numeric rows or columns, and position the results before or after the numeric data, or to remove the original (now aggregated) data completely.

This simple wizard lets you do common reporting tasks like creating a total row at the end of your table, or to display the top 10 rows with an average of the rest.

Summary Row/Column Name – assign a name for the new row or column.

Summarize – select which rows or columns to aggregate.

Choose: All, or the first/last number, or all except the first/last number

Choose: Rows or Columns

Aggregation

Select whether to use the Sum, Average or other summary function. Only Number Columns can be Totalled.

Position

Choose whether to position the new row or column before or after the remaining rows/columns.

Options

Remove selected rows / columns – check this box to remove the rows or columns that were aggregated.