Transformations Preferences


Preference Group/Preference

Description

   PivotPreferences

 

      DefaultAggregationForNumericType

Specifies the default aggregation method to use when aggregating numeric types in the Pivot tool. The factory default is Sum.

      DefaultAggregationForOtherTypes

Specifies the default aggregation method to use when aggregating other types than numeric or string in the Pivot tool. The factory default is Count.

      DefaultAggregationForStringType

Specifies the default aggregation method to use when aggregating string types in the Pivot tool. The factory default is Concatenate.

      DefaultNamingExpressions

Lets you add naming patterns to the Column naming pattern list in the Pivot dialog.

See also:

The Preferences tab

Viewing Preferences

Preferences Examples

Setting Primary Group