Build Filtering for PivotGrid in C#.NET

KetticPivotGrid controls allow the users to add filters descriptions to your .NET application to manage the data that will be displayed. By using the data filtering functionality in KetticPivotGrid, the users can use the group filtering options to operate data to view data exactly in Pivot. These functionalities are available in context menus and dialogs that are similar to options in MS Excel for the end users. KetticPivotGrid control provides two types of filtering, the Reports filtering and the Group Filters, to filter data items and groups that will be displayed in KetticPivotGrid.

The filtering functionality is able to filter data items to be displayed in the reports which are created by the KetticPivotGrid control in C# Windows Forms applications. This feature will help the users of your application to view a report containing the records that has common properties. KetticPivotGrid control will perform the report filtering before calculating the aggregated information.

The default setting hides the report filters, so we need to show the report filters elements in the report filters area. The simple C# code snippet below shows how to display the report filters.

this.ketticPivotGrid1.DisplayFilterArea = true;

KetticPivotGrid control provides the group filtering mechanism for the users to add filter conditions to the group descriptions in C# Windows Forms applications. By using this sorting feature, the users are able to specify the groups generated that will be shown in PivotGrid. KetticPivotGrid control contains two types of group filters available to the users.

To enable or disable group filtering functionality, we need to use the EnableGroupFiltering property. The default setting enables the group filtering as the C# code below.

this.ketticPivotGrid1.EnableGroupFiltering = true;