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.v20.1.dll

Declaration

[DefaultValue(DefaultBoolean.Default)]
[XtraSerializableProperty]
public virtual DefaultBoolean PopupExcelFilterShowAllValues { get; set; }
<DefaultValue(DefaultBoolean.Default)>
<XtraSerializableProperty>
Public Overridable Property PopupExcelFilterShowAllValues As DefaultBoolean

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.

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