PivotField.ChildField Property (Excel)
Returns a PivotField object that represents the child field for the specified field (if the field is grouped and has a child field). Read-only.
Syntax
expression .ChildField
expression A variable that represents a PivotField object.
Remarks
If the specified field has no child field, this property causes an error.
This property is not available for OLAP data sources.
Example
This example displays the name of the child field for the field named "REGION2."
Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable
MsgBox "The name of the child field is " & _
pvtTable.PivotFields("REGION2").ChildField.Name