數據篩選是我們常用的功能，本文通過一個具體的事例為大家展示DevExpress 是如何實現對特定字段進行數據篩選的。

下面的事例，目的是篩選出Country字段中含有 Brazil 或USA的數據，代碼如下：

C#

using DevExpress.XtraPivotGrid;

PivotGridField field = pivotGridControl1.Fields["Country"];
// Lock the control to prevent excessive updates when multiple properties are modified.
pivotGridControl1.BeginUpdate(); 
try {
   // Clear the filter value collection and add two items to it.
   field.FilterValues.Clear();
   field.FilterValues.Add("Brazil");
   field.FilterValues.Add("USA");
   // Specify that the control should only display the records 
   // which contain the specified values in the Country field.
   field.FilterValues.FilterType = DevExpress.Data.PivotGrid.PivotFilterType.Included;
}
finally {
   // Unlock the control.
   pivotGridControl1.EndUpdate();
}

VB

Imports DevExpress.XtraPivotGrid

Dim field As PivotGridField = PivotGridControl1.Fields("Country")
' Lock the control to prevent excessive updates when multiple properties are modified.
PivotGridControl1.BeginUpdate()
Try
   ' Clear the filter value collection and add two items to it.
   field.FilterValues.Clear()
   field.FilterValues.Add("Brazil")
   field.FilterValues.Add("USA")
   ' Specify that the control should only display the records 
   ' which contain the specified values in the Country field.
   field.FilterValues.FilterType = DevExpress.Data.PivotGrid.PivotFilterType.Included
Finally
   ' Unlock the control.
   PivotGridControl1.EndUpdate()
End Try

慧都學院2017全新DevExpress線下研修班火熱報名中！