Item Method (CalculatedItems Collection)

Applies To

CalculatedItems collection object.

Description

Returns a single PivotItem object from a CalculatedItems collection.

Syntax

expression.Item(Index)

expression Required. An expression that returns a CalculatedItems object.

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

Example

This example hides calculated item one.

Worksheets(1).PivotTables(1).PivotFields("Year") _
    .CalculatedItems.Item(1).Visible = False