PivotItem.ParentItem Property
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). Read-only.
Syntax
expression.ParentItem
expression A variable that represents a PivotItem object.
Remarks
This property isn't available for OLAP data sources.
Example
This example displays the name of the parent item for the item that contains the active cell.
| Visual Basic for Applications |
|---|
|