PivotField.GroupLevel (Excel)

Returns the placement of the specified field within a group of fields (if the field is a member of a grouped set of fields).

This property is not available for OLAP data sources. The highest-level parent field (leftmost parent field) is level one, its child is level two, and so on.

Dim lngGroupLevel As Long
lngGroupLevel = ActiveCell.PivotField.GroupLevel