Skip to main content

Filter Button and Dropdown

Filter buttons are displayed within field headers and can be clicked to invoke the filter dropdown. This window allows end-users to filter the data by selecting the field values which will be included in the resulting data subset to calculate summaries. Check boxes for field values that are currently filtered out are grayed. These values cannot be used for filtering.

The table below lists the main properties which affect the appearance and behavior of the filter button and dropdown window.

Visibility

A field’s Options.Filtering property.

This option can be overridden by the pivot grid’s OptionsCustomize.Filtering property.

Custom Draw Event

The pivot grid’s OnCustomDrawFieldHeader event.

Filter Criteria

A field’s Filter property.

Behavior

The pivot grid’s OptionsCustomize.FilterResizable property.

A field’s Options.FilteringPopupIncrementalFiltering property.

Size

The pivot grid’s OptionsView.FilterDropDownMaxItemCount and OptionsView.FilterDropDownWidth properties.

Context Menu

Refer to the Field Header Context Menu topic.

HitTest Information

The HitTest.HitAtButton property.