Data types in the pivot table

Some pivot table properties use the set data types Column Selector and Order Specifier.

Column Selector

A comma-separated list of positive integers numbering 0 for the first column and n-1 for the last column in a table of n columns.

Example: The table has four columns. A column selection of "0,3,1" selects the first, the last, and the second column.

The Display Selection property uses the Column Selector data type.

Order Specifier

A comma-separated list of positive integers numbering 0 for the first column and n-1 for the last column in a table of n columns. Positive values specify ascending values, and negative values specify descending order.

Example: The table has four columns. An order specifier of "-0,3" specifies an descending order on the first column and an ascending order on the last column.

The Output Order and Hierarchies input order properties use the Order Specifier data type.

There is a difference between not setting a value and specifying an empty value. If a value is not set, all or nothing may be selected, depending on the context. The empty value always means the empty set.