PivotField.PropertyOrder Property

Valid only for PivotTable fields that are member property fields. Returns an Integer indicating the display position of the member property within the cube field to which it belongs. Read/write.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Property PropertyOrder As Integer
    Get
    Set
'Usage
Dim instance As PivotField
Dim value As Integer

value = instance.PropertyOrder

instance.PropertyOrder = value
int PropertyOrder { get; set; }

Property Value

Type: System.Int32

Remarks

Setting this property will rearrange the order of the properties for this cube field. This property is one-based. The allowable range is from one to the maximum number of member property fields being displayed for the hierarchy.

If the IsMemberProperty property is False, using the PropertyOrder property will create a run-time error.

See Also

Reference

PivotField Interface

PivotField Members

Microsoft.Office.Interop.Excel Namespace