How to: Change the Prefilter Criteria in Code

The following code shows how to filter a Pivot Grid Control's underlying data source using the Prefilter. The filter selects records that contain 'USA' or 'UK' strings in the Country field.

using DevExpress.Data.Filtering;

//...

pivotgridControl1.Prefilter.CriteriaString = "[" + fieldCountry.PrefilterColumnName + 
                "] = 'UK' OR [" + fieldCountry.PrefilterColumnName + "] = 'USA'";