2.2.5.4.3.1 Pivot Field Sorting

A Pivot Field (section 2.2.5.4.3) has a sort order specified if the PivotTable (section 2.2.5) is recalculated and the Pivot Field (section 2.2.5.4.3) is on the row axis (section 2.2.5.4.9.2) or column axis (section 2.2.5.4.9.3).

A Pivot Field is sorted depending on the setting of the fAutoSort field of SXVDEx (section 2.4.310).

If the fAutoSort field of SXVDEx is equal to 0, then the sort order is specified depending on the value of the fTensorSort field of SXVDTEx record (section 2.4.311) of the Pivot Field.

fTensorSort field of SXVDTEx	Meaning
0 or SXVDTEx record not present	The order is determined by the order of the SXVI records (section 2.4.312) for this Pivot Field.
1	The order is determined by the OLAP data source. Only valid for an OLAP PivotTable view (section 2.2.5.4.2).

If the fAutoSort field of SXVDEx is equal to 1, then sorting is in ascending or descending order according to the fAscendSort field of SXVDEx. What is sorted depends on the following:

SxcAutoSort class of pivot field presence	isxdiAutoSort field of SXVDEx	Meaning
Not Present	Greater than or equal to 0	Sorting is based on the values in the cells in the PivotTable data area (section 2.2.5.4.10.1.4) that are specified by the data item (section 2.2.5.4.9.5.1) referenced by the isxdiAutoSort field of SXVDEx.
Not Present	-1	Sorting is based on the values of the pivot items (section 2.2.5.4.4) themselves.
Present		Sorting is either based on the values in the cells in the PivotTable data area or on the values of member properties (section 2.2.5.4.6) associated with this pivot field as specified by the SxcSXRule class (section 2.2.5.1.1.1.11) in the SxcAutoSort class (section 2.2.5.1.1.1.14).