Subtotal

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 Columns – select columns to be subtotalled by position or By Name. All unique combinations of values from the selected columns will be grouped.

Aggregation – select the aggregation to use for numeric columns when there are duplicate values in the selected column.

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).

Updated for v10.