Category / Section
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.
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