PivotField.PropertyOrder (Excel)

Valid only for PivotTable fields that are member property fields. Returns a Long indicating the display position of the member property within the cube field to which it belongs.

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 creates a run-time error.


ActiveCell.PivotField.PropertyOrder =