PivotItem.ParentItem (Excel)
Returns a PivotItem object that represents the parent PivotTable item in the parent PivotField object (the field must be grouped so that it has a parent).
This property isn't available for OLAP data sources.
Dim pvtiParentItem As PivotItem
Set pvtiParentItem = ActiveCell.PivotItem.ParentItem