This Analytics Edge wizard is used to create an aggregate row or column, like Total or Average. You can choose to aggregate only the first or last group of rows or columns, and position the results before or after the data, or to remove the summarized 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 and an average of the rest.
Summarize – select whether you want to aggregate rows or columns in the current table.
Select Rows / Columns – allows you to choose all rows, just the top N rows, or everything expect the top N rows. This last option is useful for top 10 and average of the rest reports.
Aggregate – select whether to use the Sum, Average or other summary function.
Position – if all rows or columns are not removed, choose whether to position the summary row or column before or after the numeric data. Note that if you have multiple text or date columns in the table, a summary column positioned ‘Before’ will appear where the first numeric column was.
Name – assign a name for the new row or column.
Do not remove selected rows / columns – check this box to add the summary row / column to the table, otherwise the selected rows / columns will be replaced with the summary.
New in version 1.3.1