Filter Panel

  • 2 minutes to read

The Filter Panel is displayed at the bottom of the PivotGridControl. This panel shows an existing filter expression (active or inactive) with a set of buttons to enable/disable or clear the filter.

Filter Panel Elements


API Description
PivotGridControl.ShowPrefilterPanelMode Specifies whether to display the filter panel within the PivotGridControl.
PivotGridControl.PrefilterPanelText Specifies the text displayed within the filter panel.
PivotGridControl.CustomPrefilterDisplayText This event allows you to display custom text within the filter panel.

Previous and New Filter Panels

The PivotGridControl v20.1 and later supports the new filter panel:

The previous filter panel displays a filter string.

The new filter panel displays a filter expression as a set of blocks with different colors for each block type (field name, field value, date-time function).

To use the new filter panel: