Excel.PivotField.GroupLevel.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PivotField.GroupLevel property (Excel)	vbaxl10.chm240082	vbaxl10.chm240082	Excel.PivotField.GroupLevel	fc017652-bded-4655-03df-79cfa733b12e	05/04/2019	medium

PivotField.GroupLevel property (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). Read-only.

Syntax

expression.GroupLevel

expression A variable that represents a PivotField object.

Remarks

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.

Example

This example displays a message box if the field that contains the active cell is the highest-level parent field.

Worksheets("Sheet1").Activate 
If ActiveCell.PivotField.GroupLevel = 1 Then 
 MsgBox "This is the highest-level parent field." 
End If

[!includeSupport and feedback]