Item Method (PivotFields Collection)

Applies To

PivotFields collection object.

Description

Returns a single PivotField object from a PivotFields collection.

Syntax

expression.Item(Index)

expression Required. An expression that returns a PivotFields object.

Index Required Variant. The name or index number of the pivot field.

Example

This example makes the Year field a row field in PivotTable one on Sheet3.

Worksheets("sheet3").PivotTables(1) _
    .PivotFields.Item("year").Orientation = xlRowField