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.