ParentShowDetail Property

Applies To

PivotItem Object.

Description

True if the specified item is showing because one of its parents is showing detail; False if the specified item is not showing because one of its parents is hiding detail. This property is only available if the item is grouped. Read-only.

Example

This example displays a message if the pivot item that contains the active cell is visible because its parent item is showing detail.

Worksheets("Sheet1").Activate
Set pvtItem = ActiveCell.PivotItem
If pvtItem.ParentShowDetail = True Then
    MsgBox "Parent item is showing detail"
End If