PivotFilter
Contents
[
Hide
]PivotFilter class
Represents a PivotFilter in PivotFilter Collection.
Properties
| Name | Type | Description |
|---|---|---|
| UseWholeDay | boolean | |
| AutoFilter | AutoFilter | Gets the autofilter of the pivot filter. |
| FilterType | Number | Gets the autofilter type of the pivot filter. The value of the property is PivotFilterType integer constant. |
| FieldIndex | Number | Gets the field index of the pivot filter. |
| FilterCategory | Number | The value of the property is FilterCategory integer constant. |
| Value1 | String | Gets the string value1 of the label pivot filter. |
| Value2 | String | Gets the string value2 of the label pivot filter. |
| MeasureFldIndex | Number | Gets the measure field index of the pivot filter. |
| ValueFieldIndex | Number | |
| MeasureCubeFieldIndex | Number | |
| MemberPropertyFieldIndex | Number | Gets the member property field index of the pivot filter. |
| Name | String | Gets the name of the pivot filter. |
| EvaluationOrder | Number | Gets the Evaluation Order of the pivot filter. |
Methods
| Name | Description |
|---|---|
| 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: Number
PivotFilter.FieldIndex property
Gets the field index of the pivot filter.
Type: Number
PivotFilter.FilterCategory property
The value of the property is FilterCategory integer constant.
Type: Number
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: Number
PivotFilter.ValueFieldIndex property
Type: Number
PivotFilter.MeasureCubeFieldIndex property
Type: Number
PivotFilter.MemberPropertyFieldIndex property
Gets the member property field index of the pivot filter.
Type: Number
PivotFilter.Name property
Gets the name of the pivot filter.
Type: String
PivotFilter.EvaluationOrder property
Gets the Evaluation Order of the pivot filter.
Type: Number