Index (Property)

Applies To:

PivotLabel object, PivotFact object, Column object

Description:

Returns or sets the number in which values display. For example if two Pivot top labels, Units and Item ID, display in the Outliner in that order, then the Units top label has an index of 1, and the Item ID top label has an index of 2. If you assign Units an index of 2, then it is the equivalent of dragging Units into the Outliner so that it is the second in order, after Item ID.

Action:

Read-write, PivotLabel and PivotFact

Read-only, Column

Example 1:

This example shows how to change the position of a Pivot fact:

ActiveDocument.Sections["SalesPivot"].Facts["Unit Sales"].Index=3

Example 2:

This example shows how to change the position of a column:

ActiveDocument.Sections["SalesResults"].Columns["Unit Sales"].Index=3