How to add new filter expressions in the pivotgridcontrol
One can achieve the certain advanced level filtering operations in our inbuilt PivotEngine by adding the following code snippet in the code behind file.
C#
pivotGrid1.PivotEngine.Filters.Add (new FilterExpression() {Name = "SomeUniqueName", Expression = "Country = Canada AND Product = Bike AND (Date = FY 2005 OR Date = FY 2007)" });
pivotGrid1.Refresh ();
Figure: Normal Pivot Grid
Figure: Pivot Grid after applying custom filter
