Click or drag to resize

PivotItem Properties

The PivotItem type exposes the following members.

Properties
Name Description
Public property DrillAcross
Specifies a boolean value that indicates whether attribute hierarchies nested next to each other on a PivotTable row or column will offer drilling "across" each other or not
Public property HasChildItems
Specifies a boolean value that indicates whether the approximate number of child items for this item is greater than zero.
Public property IsCalculatedItem
Specifies a boolean value that indicates whether this item is a calculated member
Public property IsChar
Specifies a boolean value that indicates whether the item has a character value.
Public property IsExpaned
Specifies a boolean value that indicates whether this item has been expanded in the PivotTable view.
Public property IsHidden
Specifies a boolean value that indicates whether the item is hidden.
Public property IsHiddenDetails
Specifies a boolean value that indicates whether the details are hidden for this item.
Public property IsMissing
Specifies a boolean value that indicate whether the item has a missing value.
Public property ItemType
Specifies the type of the item. Value of 'default' indicates a grand total as the last row item value
Public property UserCaption
Specifies the user caption of the item.
Top
See Also