property Pivot.DisplayFilterList as FilterListEnum
Indicates the type of filters displayed by the columns.

TypeDescription
FilterListEnum A FilterListEnum expression that specifies the options for filtering box being shown when the user clicks the drop down filter button.
By default, the DisplayFilterList property is exFilterListDefault, which is a bit-OR combination of : exAllItems | exSortItemsAsc | exShowCheckBox | exShowFocusItem | exShowExclude. For instance, you can use the DisplayFilterList property to allow displaying the drop down filter in the column's header, if the DisplayFilterList property is exNoItems(2), or you can hide the Exclude field, by setting the DisplayFilterList property on exAllItems | exSortItemsAsc | exShowCheckBox | exShowFocusItem. The FilterInclude property determines the items to be shown when the user applies a filter. The FilterCriteria property determines whether the OR or AND is used between columns. You can use the FilterBarPromptVisible property to show or hide the control's filter prompt field. The SortType property of the Column object determines the type of the filtering box being displayed as shown bellow:

The following screen shot shows the filtering box, if the SortType property is SortString:

The following screen shot shows the filtering box, if the SortType property is SortDate: