Filtering

  • 2 minutes to read

End users can use a field's filter popup to apply a filter criteria to a field and a filter editor to apply it to the entire control.

Filter Popup

The filter popup allows end users to filter certain filter, column or row fields. To apply filtering to a field, click the filter button in the field header and select field values that should be displayed in the pivot grid:

pivotgrid_datafiltering

The Excel-style filter popup's content depends on the type of data the related field displays. In the "Values" tab, end users can select specific field values from the Pivot Grid. The "Filters" tab supplies users with additional options related to the field type. For example, when filtering a string field, you can show only those records that begin with 'C':

wpf_filter_excel_style

The filter drop-down, invoked for fields arranged into a group, has a tree-like interface and allows you to manipulate the values of all fields in the group.

pivotgrid_EUC_groupfilter

Filter Editor

The Filter Editor allows you to build complex filter criteria with an unlimited number of filter conditions, combined by logical operators. To invoke the Filter Editor at runtime, right-click a field header area or a field header, and choose Show Filter from the context menu:

pivotgrid_filter

The "Show Filter" option invokes the Filter Editor. See Filter Editor for details.

filter_editor_wpf

Filter Panel

Once the Filter has been applied, the PivotGridControl shows the Filter Panel at the bottom. The Filter Panel displays filter criteria text. This panel also contains buttons used to disable/enable and clear the filter.

pivotgrid_filterpanel

The Filter Panel contains the following elements:

  • Enable/Disable Filter check box
    End users can click this check box to enable/disable the current filter.
  • Filter Expression text
    Shows applied filter expressions.
  • The MRU filter button
    Displays the most recently used filter criteria.
  • Edit Filter button
    Invokes the Filter Editor.
  • Clear Filter button
    Clears the current filter.