XlPivotFilterType Enumeration

The type of filter applied.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Public Enumeration XlPivotFilterType
'Usage
Dim instance As XlPivotFilterType
public enum XlPivotFilterType

Members

Member name Description
xlTopCount Filters for the specified number of values from the top of a list
xlBottomCount Filters for the specified number of values from the bottom of a list
xlTopPercent Filters for the specified percentage of values from a list
xlBottomPercent Filters for the specified percentage of values from the bottom of a list
xlTopSum Sum of the values from the top of the list
xlBottomSum Sum of the values from the bottom of the list
xlValueEquals Filters for all values that match the specified value
xlValueDoesNotEqual Filters for all values that do not match the specified value
xlValueIsGreaterThan Filters for all values that are greater than the specified value
xlValueIsGreaterThanOrEqualTo Filters for all values that are greater than or match the specified value
xlValueIsLessThan Filters for all values that are less than the specified value
xlValueIsLessThanOrEqualTo Filters for all values that are less than or match the specified value
xlValueIsBetween Filters for all values that are between a specified range of values
xlValueIsNotBetween Filters for all values that are not between a specified range of values
xlCaptionEquals Filters for all captions that match the specified string
xlCaptionDoesNotEqual Filters for all captions that do not match the specified string
xlCaptionBeginsWith Filters for all captions beginning with the specified string
xlCaptionDoesNotBeginWith Filters for all captions that do not begin with the specified string
xlCaptionEndsWith Filters for all captions that end with the specified string
xlCaptionDoesNotEndWith Filters for all captions that do not end with the specified string
xlCaptionContains Filters for all captions that contain the specified string
xlCaptionDoesNotContain Filters for all captions that do not contain the specified string
xlCaptionIsGreaterThan Filters for all captions that are greater than the specified value
xlCaptionIsGreaterThanOrEqualTo Filters for all captions that are greater than or match the specified value
xlCaptionIsLessThan Filters for all captions that are less than the specified value
xlCaptionIsLessThanOrEqualTo Filters for all captions that are less than or match the specified value
xlCaptionIsBetween Filters for all captions that are between a specified range of values
xlCaptionIsNotBetween Filters for all captions that are not between a specified range of values
xlSpecificDate Filters for all dates that match a specified date
xlNotSpecificDate Filters for all dates that do not match a specified date
xlBefore Filters for all dates before a specified date
xlBeforeOrEqualTo Filters for all dates on or before a specified date
xlAfter Filters for all dates after a specified date
xlAfterOrEqualTo Filters for all dates on or after a specified date
xlDateBetween Filters for all dates that are between a specified range of dates
xlDateNotBetween
xlDateTomorrow Filters for all dates that apply to the next day
xlDateToday Filters for all dates that apply to the current date
xlDateYesterday Filters for all dates that apply to the previous day
xlDateNextWeek Filters for all dates that apply to the next week
xlDateThisWeek Filters for all dates that apply to the current week
xlDateLastWeek Filters for all dates that apply to the previous week
xlDateNextMonth Filters for all dates that apply to the next month
xlDateThisMonth Filters for all dates that apply to the current month
xlDateLastMonth Filters for all dates that apply to the previous month
xlDateNextQuarter Filters for all dates that apply to the next quarter
xlDateThisQuarter Filters for all dates that apply to the current quarter
xlDateLastQuarter Filters for all dates that apply to the previous quarter
xlDateNextYear Filters for all dates that apply to the next year
xlDateThisYear Filters for all dates that apply to the current year
xlDateLastYear Filters for all dates that apply to the previous year
xlYearToDate Filters for all values that are within one year of a specified date
xlAllDatesInPeriodQuarter1 Filters for all dates in Quarter1
xlAllDatesInPeriodQuarter2 Filters for all dates in Quarter2
xlAllDatesInPeriodQuarter3 Filters for all dates in Quarter3
xlAllDatesInPeriodQuarter4 Filters for all dates in Quarter 4
xlAllDatesInPeriodJanuary Filters for all dates in January
xlAllDatesInPeriodFebruary Filters for all dates in February
xlAllDatesInPeriodMarch Filters for all dates in March
xlAllDatesInPeriodApril Filters for all dates in April
xlAllDatesInPeriodMay Filters for all dates in May
xlAllDatesInPeriodJune Filters for all dates in June
xlAllDatesInPeriodJuly Filters for all dates in July
xlAllDatesInPeriodAugust Filters for all dates in August
xlAllDatesInPeriodSeptember Filters for all dates in September
xlAllDatesInPeriodOctober Filters for all dates in October
xlAllDatesInPeriodNovember Filters for all dates in November
xlAllDatesInPeriodDecember Filters for all dates in December

See Also

Reference

Microsoft.Office.Interop.Excel Namespace