Share via

FilterFunction Property

  • Article

FilterFunction property as it applies to the PivotField object.

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.

SheetFilterFunction

SheetFilterFunction can be one of these SheetFilterFunction constants.
ssFilterFunctionExclude
ssFilterFunctionInclude

expression.FilterFunction

*expression   * Required. An expression that returns a Criteria object.

Applies to | Criteria Object | PivotField Object

See Also | Filter Property