PivotTable.DataPivotField Property

Syntax

expression.DataPivotField

expression A variable that represents a PivotTable object.

Example

This example moves the second PivotItem object to the first position. It assumes a PivotTable exists on the active worksheet and that the PivotTable contains data fields.

Sub UseDataPivotField() Dim pvtTable As PivotTable Set pvtTable = ActiveSheet.PivotTables(1) ' Move second PivotItem to the first position in PivotTable. pvtTable.DataPivotField.PivotItems(2).Position = 1 End Sub

See also:

• PivotTable Object
• PivotTable Object Members