How to add new filter expressions in the pivotgridcontrol

1 min read

One can achieve the certain advanced level filtering operations in our inbuilt PivotEngine by adding the following code snippet in the code behind file.

pivotGrid1.PivotEngine.Filters.Add (new FilterExpression() {Name = "SomeUniqueName", Expression = "Country = Canada AND Product = Bike AND (Date = FY 2005 OR Date = FY 2007)" });
pivotGrid1.Refresh ();

$C:\Users\labuser\Dropbox\Screenshots\Screenshot 2014-06-05 18.22.39.png$

Figure: Normal Pivot Grid

$C:\Users\labuser\Dropbox\Screenshots\Screenshot 2014-06-05 18.22.26.png$

Figure: Pivot Grid after applying custom filter

Did you find this information helpful?

Yes

Comments (0)

How to add new filter expressions in the pivotgridcontrol

Access denied