Skip to main content

Filtering in Code

Filter the PivotGrid Data

Use the PivotGridControl.FilterString and PivotGridControl.FilterCriteria properties to apply a filter to the pivot grid.

End users can edit the filter criteria in the Filter Editor.

Filter the Field Values

Add filter values to the PivotGridField.FilterValues collection. The value type should equals the field’s type.

The FieldFilterValues.FilterType property determines whether the specified filter values should be displayed or hidden.


The complete sample project How to: Apply Filter to a Field is available in the DevExpress Examples repository.

See Also