PivotItem Object

Description

Represents an item in a pivot field. The items are the individual data entries in a field category. The PivotItem object is a member of the PivotItems collection. The PivotItems collection contains all the items in a PivotField object.

Using the PivotItem Object

Use PivotItems(index), where index is the pivot item index number or name, to return a single PivotItem object. The following example hides all entries in PivotTable one on Sheet3 that contain "1998" in the Year field.

Worksheets("Sheet3").PivotTables(1) _
    .PivotFields("Year").PivotItems("1998").Visible = False
Properties

Application property, ChildItems property, Creator property, DataRange property, Formula property, IsCalculated property, LabelRange property, Name property, Parent property, ParentItem property, ParentShowDetail property, Position property, RecordCount property, ShowDetail property, SourceName property, Value property, Visible property.

Methods

Delete method.