ParentItem Property

Applies To

PivotItem object.

Description

Returns a PivotItem object that represents the parent pivot item in the parent PivotField object (the field must be grouped so that it has a parent). Read-only.

Example

This example displays the name of the parent item for the item that contains the active cell.

Worksheets("Sheet1").Activate
MsgBox "This item is a subitem of " & _
    ActiveCell.PivotItem.ParentItem.Name