ChildItems Property

Applies To

PivotField object, PivotItem object.

Description

Returns an object that represents either a single pivot item (a PivotItem object, Syntax 1) or a collection of all the pivot 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 pivot item name or number (can be an array to specify more than one item).

Example

This example adds the names of all the child items of the item named "vegetables" to a list on a new worksheet.

Set nwSheet = Worksheets.Add
nwSheet.Activate
Set pvtTable = Worksheets("Sheet2").Range("A1").PivotTable
rw = 0
For Each pvtItem In pvtTable.PivotFields("product").PivotItems("vegetables") _
        .ChildItems
    rw = rw + 1
    nwSheet.Cells(rw, 1).Value = pvtItem.Name
Next pvtItem