Item Method (CalculatedFields Collection)

Applies To

CalculatedFields collection object.

Description

Returns a single PivotField object from a CalculatedFields collection.

Syntax

expression.Item(Index)

expression Required. An expression that returns a CalculatedFields object.

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

Example

This example sets the formula for calculated field one.

Worksheets(1).PivotTables(1).CalculatedFields.Item(1) _
    .Formula = "=Revenue - Cost"