To learn more about filtering, see Filtering Overview.

Example
The example below shows how to apply complex filter criteria in code using the ActiveFilterCriteria property.
C# |
using DevExpress.Data.Filtering;
pivotGridControl.ActiveFilterCriteria = new GroupOperator(GroupOperatorType.And,
new InOperator(fieldTrademark.PrefilterColumnName, new string[] { "Chevrolet", "Chrysler", "Dodge", "Ford" }),
new InOperator(fieldBodyStyle.PrefilterColumnName, new string[] { "Coupe" }));
|
VB |
Imports DevExpress.Data.Filtering
pivotGridControl.ActiveFilterCriteria = New GroupOperator(GroupOperatorType.And,
New InOperator(fieldTrademark.PrefilterColumnName, New String() {"Chevrolet", "Chrysler", "Dodge", "Ford"}),
New InOperator(fieldBodyStyle.PrefilterColumnName, New String() {"Coupe"}))
|