How to: Apply Filter to a Field

• Jun 27, 2019

The example below shows how to apply filtering to the ‘fieldTradeMark’ field by adding ‘Chevrolet’ or ‘Chrysler’ to the PivotGridFieldBase.FilterValues collection.

C#

pivotGridControl.BeginUpdate();
try {
    fieldTrademark.FilterValues.Clear();
    fieldTrademark.FilterValues.FilterType = PivotFilterType.Included;
    fieldTrademark.FilterValues.Add("Chevrolet");
    fieldTrademark.FilterValues.Add("Chrysler");
}
finally {
    pivotGridControl.EndUpdate();
}

VB.NET

pivotGridControl.BeginUpdate()
Try
    fieldTrademark.FilterValues.Clear()
    fieldTrademark.FilterValues.FilterType = PivotFilterType.Included
    fieldTrademark.FilterValues.Add("Chevrolet")
    fieldTrademark.FilterValues.Add("Chrysler")
Finally
    pivotGridControl.EndUpdate()
End Try