PivotFilter

PivotFilter class

Represents a PivotFilter in PivotFilter Collection.

Properties

NameTypeDescription
UseWholeDayboolean
AutoFilterAutoFilterGets the autofilter of the pivot filter.
FilterTypeintGets the autofilter type of the pivot filter. The value of the property is PivotFilterType integer constant.
FieldIndexintGets the field index of the pivot filter.
FilterCategoryintThe value of the property is FilterCategory integer constant.
Value1StringGets the string value1 of the label pivot filter.
Value2StringGets the string value2 of the label pivot filter.
MeasureFldIndexintGets the measure field index of the pivot filter.
ValueFieldIndexint
MeasureCubeFieldIndexint
MemberPropertyFieldIndexintGets the member property field index of the pivot filter.
NameStringGets the name of the pivot filter.
EvaluationOrderintGets the Evaluation Order of the pivot filter.

Methods

NameDescription
getTop10Value
getLabels
getNumberValues
getDateTimeValues

PivotFilter.UseWholeDay property

Type: boolean

PivotFilter.AutoFilter property

Gets the autofilter of the pivot filter.

Type: AutoFilter

PivotFilter.FilterType property

Gets the autofilter type of the pivot filter. The value of the property is PivotFilterType integer constant.

Type: int

PivotFilter.FieldIndex property

Gets the field index of the pivot filter.

Type: int

PivotFilter.FilterCategory property

The value of the property is FilterCategory integer constant.

Type: int

PivotFilter.Value1 property

Gets the string value1 of the label pivot filter.

Type: String

PivotFilter.Value2 property

Gets the string value2 of the label pivot filter.

Type: String

PivotFilter.MeasureFldIndex property

Gets the measure field index of the pivot filter.

Type: int

PivotFilter.ValueFieldIndex property

Type: int

PivotFilter.MeasureCubeFieldIndex property

Type: int

PivotFilter.MemberPropertyFieldIndex property

Gets the member property field index of the pivot filter.

Type: int

PivotFilter.Name property

Gets the name of the pivot filter.

Type: String

PivotFilter.EvaluationOrder property

Gets the Evaluation Order of the pivot filter.

Type: int

getTop10Value()

getLabels()

getNumberValues()

getDateTimeValues()