Weight Columns

Weighted columns can be used to assign a weight that is inversely proportional to the number of data points in a cell to alter the distribution of the data set.

These three important points to know about using weight fields in relation to calculated columns.

1. Calculated columns do not use weight columns that are defined for data columns used in the calculated column's expression.
2. Calculated columns themselves, like any other column, can have weight columns.
3. Calculated columns can themselves be used as a weight column.

Points 2 and 3 are a result of a calculated column, once defined, to be no different from any other data column. Observation 1 is the most important message to take away from this section.

Note: Calculated columns do not use weight columns that are defined for data columns used in the calculated column's expression.