Item Method (PivotFields Collection)

Item Method (PivotFields Collection)

         Example         Applies To

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 PivotTable field.

Remarks

The text name of the object is the value of the Name and Value properties. For an OLAP data source, the value is equal to the value of the SourceName property, and for other data sources, the value is equal to the value of the Caption property.