XlPivotFilterType Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
The type of filter applied.
public enum class XlPivotFilterType
public enum XlPivotFilterType
Public Enum XlPivotFilterType
- Inheritance
-
XlPivotFilterType
Fields
xlAfter | 33 | Filters for all dates after a specified date |
xlAfterOrEqualTo | 34 | Filters for all dates on or after a specified date |
xlAllDatesInPeriodApril | 60 | Filters for all dates in April |
xlAllDatesInPeriodAugust | 64 | Filters for all dates in August |
xlAllDatesInPeriodDecember | 68 | Filters for all dates in December |
xlAllDatesInPeriodFebruary | 58 | Filters for all dates in February |
xlAllDatesInPeriodJanuary | 57 | Filters for all dates in January |
xlAllDatesInPeriodJuly | 63 | Filters for all dates in July |
xlAllDatesInPeriodJune | 62 | Filters for all dates in June |
xlAllDatesInPeriodMarch | 59 | Filters for all dates in March |
xlAllDatesInPeriodMay | 61 | Filters for all dates in May |
xlAllDatesInPeriodNovember | 67 | Filters for all dates in November |
xlAllDatesInPeriodOctober | 66 | Filters for all dates in October |
xlAllDatesInPeriodQuarter1 | 53 | Filters for all dates in Quarter1 |
xlAllDatesInPeriodQuarter2 | 54 | Filters for all dates in Quarter2 |
xlAllDatesInPeriodQuarter3 | 55 | Filters for all dates in Quarter3 |
xlAllDatesInPeriodQuarter4 | 56 | Filters for all dates in Quarter 4 |
xlAllDatesInPeriodSeptember | 65 | Filters for all dates in September |
xlBefore | 31 | Filters for all dates before a specified date |
xlBeforeOrEqualTo | 32 | Filters for all dates on or before a specified date |
xlBottomCount | 2 | Filters for the specified number of values from the bottom of a list |
xlBottomPercent | 4 | Filters for the specified percentage of values from the bottom of a list |
xlBottomSum | 6 | Sum of the values from the bottom of the list |
xlCaptionBeginsWith | 17 | Filters for all captions beginning with the specified string |
xlCaptionContains | 21 | Filters for all captions that contain the specified string |
xlCaptionDoesNotBeginWith | 18 | Filters for all captions that do not begin with the specified string |
xlCaptionDoesNotContain | 22 | Filters for all captions that do not contain the specified string |
xlCaptionDoesNotEndWith | 20 | Filters for all captions that do not end with the specified string |
xlCaptionDoesNotEqual | 16 | Filters for all captions that do not match the specified string |
xlCaptionEndsWith | 19 | Filters for all captions that end with the specified string |
xlCaptionEquals | 15 | Filters for all captions that match the specified string |
xlCaptionIsBetween | 27 | Filters for all captions that are between a specified range of values |
xlCaptionIsGreaterThan | 23 | Filters for all captions that are greater than the specified value |
xlCaptionIsGreaterThanOrEqualTo | 24 | Filters for all captions that are greater than or match the specified value |
xlCaptionIsLessThan | 25 | Filters for all captions that are less than the specified value |
xlCaptionIsLessThanOrEqualTo | 26 | Filters for all captions that are less than or match the specified value |
xlCaptionIsNotBetween | 28 | Filters for all captions that are not between a specified range of values |
xlDateBetween | 35 | Filters for all dates that are between a specified range of dates |
xlDateLastMonth | 45 | Filters for all dates that apply to the previous month |
xlDateLastQuarter | 48 | Filters for all dates that apply to the previous quarter |
xlDateLastWeek | 42 | Filters for all dates that apply to the previous week |
xlDateLastYear | 51 | Filters for all dates that apply to the previous year |
xlDateNextMonth | 43 | Filters for all dates that apply to the next month |
xlDateNextQuarter | 46 | Filters for all dates that apply to the next quarter |
xlDateNextWeek | 40 | Filters for all dates that apply to the next week |
xlDateNextYear | 49 | Filters for all dates that apply to the next year |
xlDateNotBetween | 36 | |
xlDateThisMonth | 44 | Filters for all dates that apply to the current month |
xlDateThisQuarter | 47 | Filters for all dates that apply to the current quarter |
xlDateThisWeek | 41 | Filters for all dates that apply to the current week |
xlDateThisYear | 50 | Filters for all dates that apply to the current year |
xlDateToday | 38 | Filters for all dates that apply to the current date |
xlDateTomorrow | 37 | Filters for all dates that apply to the next day |
xlDateYesterday | 39 | Filters for all dates that apply to the previous day |
xlNotSpecificDate | 30 | Filters for all dates that do not match a specified date |
xlSpecificDate | 29 | Filters for all dates that match a specified date |
xlTopCount | 1 | Filters for the specified number of values from the top of a list |
xlTopPercent | 3 | Filters for the specified percentage of values from a list |
xlTopSum | 5 | Sum of the values from the top of the list |
xlValueDoesNotEqual | 8 | Filters for all values that do not match the specified value |
xlValueEquals | 7 | Filters for all values that match the specified value |
xlValueIsBetween | 13 | Filters for all values that are between a specified range of values |
xlValueIsGreaterThan | 9 | Filters for all values that are greater than the specified value |
xlValueIsGreaterThanOrEqualTo | 10 | Filters for all values that are greater than or match the specified value |
xlValueIsLessThan | 11 | Filters for all values that are less than the specified value |
xlValueIsLessThanOrEqualTo | 12 | Filters for all values that are less than or match the specified value |
xlValueIsNotBetween | 14 | Filters for all values that are not between a specified range of values |
xlYearToDate | 52 | Filters for all values that are within one year of a specified date |
Applies to
Opinia
https://aka.ms/ContentUserFeedback.
Dostępne już wkrótce: W 2024 r. będziemy stopniowo wycofywać zgłoszenia z serwisu GitHub jako mechanizm przesyłania opinii na temat zawartości i zastępować go nowym systemem opinii. Aby uzyskać więcej informacji, sprawdź:Prześlij i wyświetl opinię dla