Subtotal

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

Columns to Subtotal – 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).

Aggregation – select the aggregation to use when there are duplicate values.