PivotFilter.FilterType PivotFilter.FilterType PivotFilter.FilterType Property

Definition

Specifies the type of filter to be applied. Read-only.

public:
 property Microsoft::Office::Interop::Excel::XlPivotFilterType FilterType { Microsoft::Office::Interop::Excel::XlPivotFilterType get(); };
public Microsoft.Office.Interop.Excel.XlPivotFilterType FilterType { get; }
Public ReadOnly Property FilterType As XlPivotFilterType
Property Value

Remarks

The following table shows the filter types that can be added to a PivotField. Arguments that must be supplied to the Microsoft.Office.Interop.Excel.xlPivotFilters.Add method for that filter type are marked “Required”, and those that cannot be supplied are marked “Unavailable”.

Data Field PivotField
DataField(OLAPCubeField
Value1
Value2
xlPivotFilterTypeDataFieldDataCubeField (OLAP)Value1Value2
xlTopCountRequiredRequiredRequiredUnavailable
xlBottomCountRequiredRequiredRequiredUnavailable
xlTopPercentRequiredRequiredRequiredUnavailable
xlBottomPercentRequiredRequiredRequiredUnavailable
xlTopSumRequiredRequiredRequiredUnavailable
xlBottomSumRequiredRequiredRequiredUnavailable
xlCaptionEqualsUnavailableUnavailableRequiredUnavailable
xlCaptionDoesNotEqualUnavailableUnavailableRequiredUnavailable
xlCaptionIsGreaterThanUnavailableUnavailableRequiredUnavailable
xlCaptionIsGreaterThanOrEqualToUnavailableUnavailableRequiredUnavailable
xlCaptionIsLessThanUnavailableUnavailableRequiredUnavailable
xlCaptionIsLessThanOrEqualToUnavailableUnavailableRequiredUnavailable
xlCaptionBeginsWithUnavailableUnavailableRequiredUnavailable
xlCaptionDoesNotBeginWithUnavailableUnavailableRequiredUnavailable
xlCaptionEndsWithUnavailableUnavailableRequiredUnavailable
xlCaptionDoesNotEndWithUnavailableUnavailableRequiredUnavailable
xlCaptionContainsUnavailableUnavailableRequiredUnavailable
xlCaptionDoesNotContainUnavailableUnavailableRequiredUnavailable
xlCaptionIsBetweenUnavailableUnavailableRequiredRequired
xlCaptionIsNotBetweenUnavailableUnavailableRequiredRequired
xlValueEqualsRequiredRequiredRequiredUnavailable
xlValueDoesNotEqualRequiredRequiredRequiredUnavailable
xlValueIsGreaterThanRequiredRequiredRequiredUnavailable
xlValueIsGreaterThanOrEqualToRequiredRequiredRequiredUnavailable
xlValueIsLessThanRequiredRequiredRequiredUnavailable
xlValueIsLessThanOrEqualToRequiredRequiredRequiredUnavailable
xlValueIsBetweenRequiredRequiredRequiredRequired
xlValueIsNotBetweenRequiredRequiredRequiredRequired
xlSpecificDateUnavailableUnavailableRequiredUnavailable
xlNotSpecificDateUnavailableUnavailableRequiredUnavailable
xlBeforeUnavailableUnavailableRequiredUnavailable
xlBeforeOrEqualToUnavailableUnavailableRequiredUnavailable
xlAfterUnavailableUnavailableRequiredUnavailable
xlAfterOrEqualToUnavailableUnavailableRequiredUnavailable
xlBetweenUnavailableUnavailableRequiredUnavailable
xlNotBetweenUnavailableUnavailableRequiredUnavailable
xlFilterTodayUnavailableUnavailableUnavailableUnavailable
xlFilterYesterdayUnavailableUnavailableUnavailableUnavailable
xlFilterTomorrowUnavailableUnavailableUnavailableUnavailable
xlFilterThisWeekUnavailableUnavailableUnavailableUnavailable
xlFilterLastWeekUnavailableUnavailableUnavailableUnavailable
xlFilterNextWeekUnavailableUnavailableUnavailableUnavailable
xlFilterThisMonthUnavailableUnavailableUnavailableUnavailable
xlFilterLastMonthUnavailableUnavailableUnavailableUnavailable
xlFilterNextMonthUnavailableUnavailableUnavailableUnavailable
xlFilterThisQuarterUnavailableUnavailableUnavailableUnavailable
xlFilterLastQuarterUnavailableUnavailableUnavailableUnavailable
xlFilterNextQuarterUnavailableUnavailableUnavailableUnavailable
xlFilterThisYearUnavailableUnavailableUnavailableUnavailable
xlFilterLastYearUnavailableUnavailableUnavailableUnavailable
xlFilterNextYearUnavailableUnavailableUnavailableUnavailable
xlFilterYearToDateUnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodQuarter1UnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodQuarter2UnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodQuarter3UnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodQuarter4UnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodJanuaryUnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodFebruaryUnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodMarchUnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodAprilUnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodMayUnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodJuneUnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodJulyUnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodAugustUnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodSeptemberUnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodOctoberUnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodNovemberUnavailableUnavailableUnavailableUnavailable
xlFilterAllDatesInPeriodDecemberUnavailableUnavailableUnavailableUnavailable

Applies to