Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

2.2.5.4.3.1 Pivot Field Sorting

Office

A Pivot Field (section 2.2.5.4.3) has a sort order (2) 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 (2) 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 OLAPdata source (1). 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).

Show:
© 2015 Microsoft