FilterFunction Property
FilterFunction property as it applies to the PivotField object.
Returns or sets the filter function for the specified field. Read/write PivotFieldFilterFunctionEnum.
| PivotFieldFilterFunctionEnum can be one of these PivotFieldFilterFunctionEnum constants. |
| plFilterFunctionBottomCount |
| plFilterFunctionBottomPercent |
| plFilterFunctionBottomSum |
| plFilterFunctionExpression |
| plFilterFunctionMemberSet |
| plFilterFunctionNone |
| plFilterFunctionTopCount |
| plFilterFunctionTopPercent |
| plFilterFunctionTopSum |
expression.FilterFunction
expression Required. An expression that returns a PivotField object.
FilterFunction property as it applies to the Criteria object.
Returns or sets how the specified criteria work with the AutoFilter. If this property is set to ssFilterFunctionInclude, the specified items are displayed in the filtered list and all other items are removed. If this property is set to ssFilterFunctionExclude, the specified items are removed from the filtered list and all other items are displayed. Read/write SheetFilterFunction.
| SheetFilterFunction can be one of these SheetFilterFunction constants. |
| ssFilterFunctionExclude |
| ssFilterFunctionInclude |
expression.FilterFunction
expression Required. An expression that returns a Criteria object.