Skip to main content

PivotGridFieldOptionsFilter.PopupExcelFilterShowAllValues Property

Gets or sets whether or not filters applied to other fields affect filter values displayed for the current field in the Excel-style filter popup.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v24.1.dll

NuGet Package: DevExpress.Win.PivotGrid

Declaration

[DefaultValue(DefaultBoolean.Default)]
[XtraSerializableProperty]
public virtual DefaultBoolean PopupExcelFilterShowAllValues { get; set; }

Property Value

Type Default Description
DefaultBoolean Default

A DefaultBoolean value that specifies whether or not filters applied to other fields affect filter values displayed for the current field in the Excel-style filter popup.

Available values:

Name Description Return Value
True

The value is true.

0

False

The value is false.

1

Default

The value is specified by a global option or a higher-level object.

2

Property Paths

You can access this nested property as listed below:

Object Type Path to PopupExcelFilterShowAllValues
PivotGridField
.OptionsFilter .PopupExcelFilterShowAllValues

Remarks

The PopupExcelFilterShowAllValues property allows you to simulate the group filter behavior without merging fields into a group. This property is not in effect when you open a filter window for grouped fields when the GroupFilterMode is List.

A sample Pivot Grid contains two row fields: Trademark and Name (‘fieldTrademark’ and ‘fieldName’ in code).

ShowOnlyAvailableItems_PivotExample

If you set the PopupExcelFilterShowAllValues property to DefaultBoolean.True for the Name field, its filter popup displays car models depending on the selected Trademark values.

fieldName.OptionsFilter.PopupExcelFilterShowAllValues = DevExpress.Utils.DefaultBoolean.True;
Trademark Name
PivotGridField_ShowOnlyAvailableItems PivotGridField_ShowOnlyAvailableItems_true

If you set the PopupExcelFilterShowAllValues property to DefaultBoolean.False for the Name field, the popup displays all car models available in the underlying data source.

fieldName.OptionsFilter.PopupExcelFilterShowAllValues = DevExpress.Utils.DefaultBoolean.False;
Trademark Name
PivotGridField_ShowOnlyAvailableItems PivotGridField_ShowOnlyAvailableItems_false
See Also