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.