Edit

Excel.PivotFilterType enum

  • Reference
Package:
excel

A simple enum that represents a type of filter for a PivotField.

Remarks

[ API set: ExcelApi 1.12 ]

Fields

date = "Date"

Filters PivotItems with a date in place of a label. Note: A PivotField cannot simultaneously have a label filter and a date filter applied.
label = "Label"

Filters PivotItems based on their labels. Note: A PivotField cannot simultaneously have a label filter and a date filter applied.
manual = "Manual"

Filters specific manually selected PivotItems from the PivotTable.
unknown = "Unknown"

PivotFilterType is unknown or unsupported.
value = "Value"

Filters based on the value of a PivotItem with respect to a DataPivotHierarchy.