This Analytics Edge wizard allows you to subtotal a table based on unique values in selected columns.
It is typically used to produce summary reports from detailed data.
Select Key Columns – select columns to be subtotalled by position or By Name. All unique combinations of values from the selected columns will be grouped.
Ignore case – when performing the comparison, match rows even if they have differing upper or lower case letters.
Ignore spaces – when performing the comparison, match rows even if they differ because of different spacing (leading, trailing or within the text).
Select the aggregation to use (only Number Columns can be subtotalled) when there are duplicate values in the selected column.