PivotField.ParentItems Property
Returns an object that represents either a single PivotTable item (a PivotItem object) or a collection of all the items (a PivotItems object) that are group parents in the specified field. The specified field must be a group parent of another field. Read-only.
Syntax
expression.ParentItems(Index)
expression A variable that represents a PivotField object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Index | Optional | Variant | The number or name of the item to be returned (can be an array to specify more than one item). |
Remarks
This property isn't available for OLAP data sources.
Example
This example creates a list containing the names of all the items that are group parents in the field named "product".
| Visual Basic for Applications |
|---|
|