ChildItems Property

ChildItems Property

         Example         Applies To

Returns an object that represents either a single PivotTable item (a PivotItem object, Syntax 1) or a collection of all the items (a PivotItems object, Syntax 2) that are group children in the specified field, or children of the specified item. Read-only.

Syntax 1

expression.ChildItems(Index)

Syntax 2

expression.ChildItems

expression   Required. An expression that returns a PivotField or PivotItem object.

Index   Optional Variant. The item name or number (can be an array to specify more than one item).

Remarks

This property is not available for OLAP data sources.