PivotFilter.FilterType Property
Specifies the type of filter to be applied. Read-only.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
ReadOnly Property FilterType As XlPivotFilterType
Get
'Usage
Dim instance As PivotFilter
Dim value As XlPivotFilterType
value = instance.FilterType
XlPivotFilterType FilterType { get; }
Property Value
Type: Microsoft.Office.Interop.Excel.XlPivotFilterType
XlPivotFilterType
Remarks
The following table shows the filter types that can be added to a PivotField. Arguments that must be supplied to the Add method for that filter type are marked “Required”, and those that cannot be supplied are marked “Unavailable”.
TypexlPivotFilterType |
|---|
Data FieldPivotField |
DataField(OLAPCubeField |
Value1 |
Value2 |
xlPivotFilterType |
xlTopCount |
xlBottomCount |
xlTopPercent |
xlBottomPercent |
xlTopSum |
xlBottomSum |
xlCaptionEquals |
xlCaptionDoesNotEqual |
xlCaptionIsGreaterThan |
xlCaptionIsGreaterThanOrEqualTo |
xlCaptionIsLessThan |
xlCaptionIsLessThanOrEqualTo |
xlCaptionBeginsWith |
xlCaptionDoesNotBeginWith |
xlCaptionEndsWith |
xlCaptionDoesNotEndWith |
xlCaptionContains |
xlCaptionDoesNotContain |
xlCaptionIsBetween |
xlCaptionIsNotBetween |
xlValueEquals |
xlValueDoesNotEqual |
xlValueIsGreaterThan |
xlValueIsGreaterThanOrEqualTo |
xlValueIsLessThan |
xlValueIsLessThanOrEqualTo |
xlValueIsBetween |
xlValueIsNotBetween |
xlSpecificDate |
xlNotSpecificDate |
xlBefore |
xlBeforeOrEqualTo |
xlAfter |
xlAfterOrEqualTo |
xlBetween |
xlNotBetween |
xlFilterToday |
xlFilterYesterday |
xlFilterTomorrow |
xlFilterThisWeek |
xlFilterLastWeek |
xlFilterNextWeek |
xlFilterThisMonth |
xlFilterLastMonth |
xlFilterNextMonth |
xlFilterThisQuarter |
xlFilterLastQuarter |
xlFilterNextQuarter |
xlFilterThisYear |
xlFilterLastYear |
xlFilterNextYear |
xlFilterYearToDate |
xlFilterAllDatesInPeriodQuarter1 |
xlFilterAllDatesInPeriodQuarter2 |
xlFilterAllDatesInPeriodQuarter3 |
xlFilterAllDatesInPeriodQuarter4 |
xlFilterAllDatesInPeriodJanuary |
xlFilterAllDatesInPeriodFebruary |
xlFilterAllDatesInPeriodMarch |
xlFilterAllDatesInPeriodApril |
xlFilterAllDatesInPeriodMay |
xlFilterAllDatesInPeriodJune |
xlFilterAllDatesInPeriodJuly |
xlFilterAllDatesInPeriodAugust |
xlFilterAllDatesInPeriodSeptember |
xlFilterAllDatesInPeriodOctober |
xlFilterAllDatesInPeriodNovember |
xlFilterAllDatesInPeriodDecember |