Skip to main content

PivotGridFieldOptionsEx.FieldFilterPopupMode Property

Gets or sets the field’s pop-up filter mode.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v23.2.dll

NuGet Package: DevExpress.Win.PivotGrid


public virtual FieldFilterPopupMode FieldFilterPopupMode { get; set; }

Property Value

Type Default Description
FieldFilterPopupMode Default

A FieldFilterPopupMode value that specifies the field’s pop-up filter mode. Default value is interpreted as FieldFilterPopupMode.Excel.

Available values:

Name Description

A default filter popup type.


An Excel-style filter popup.



A Classic filter popup.


Property Paths

You can access this nested property as listed below:

Object Type Path to FieldFilterPopupMode
.Options .FieldFilterPopupMode


The Pivot Grid supports Excel-style and Classic pop-up filters. For more information, see Pop-up Filter.

You can specify the pop-up filter style at three levels:

  1. Application level

    Use the WindowsFormsSettings.ColumnFilterPopupMode static option for all controls in your application.

  2. Control level

    Use the PivotGridOptionsFilterPopup.FieldFilterPopupMode property to specify a pop-up filter’s type for the entire PivotGridControl.

pivotGridControl.OptionsFilterPopup.FieldFilterPopupMode = FieldFilterPopupMode.Excel;

This control level setting overrides the WindowsFormsSettings.ColumnFilterPopupMode global setting.

  1. Field level

    Use the PivotGridFieldOptionsEx.FieldFilterPopupMode property to define a pop-up filter for a specific field.

fieldTrademark.Options.FieldFilterPopupMode = FieldFilterPopupMode.Excel;

The field level setting overrides the control level settings.

You cannot use the Excel-style filter in the following cases:

See Also