Assembly: Pivot;
The IPivotHeaderFilterSettings interface is used to work with row or column header filtering settings.
IPivotHeaderFilterSettings
To get an object of this type, use IPivotHeaderSettings.Filter.
| Property name | Brief description | |
|
ExcludeElements | The ExcludeElements property determines whether elements are excluded from filtering settings. |
|
ExcludeSelection | The ExcludeSelection property determines the selection that must be excluded from filtering settings. |
| Property name | Brief description | |
|
AdditionalTableSourceSelSet | The AdditionalTableSourceSelSet property returns the additional selection, according to which filtering is to be executed. |
|
AttributeLinks | The AttributeLinks property returns filtering parameters by dimension attributes links. |
|
Condition | The Condition property determines filtering expression parameters. |
|
ConditionType | The ConditionType property determines the condition type, according to which data is filtered. |
|
ConditionValueA | The ConditionValueA property determines the first value that is used in data filtering. |
|
ConditionValueB | The ConditionValueB property determines the second value that is used in data filtering. |
|
Enabled | The Enabled property determines whether data is filtered in table. |
|
FilterSources | The FilterSources property determines whether external filters are used for filtering. |
|
KeepNeighbors | The KeepNeighbors property determines whether data is filtered by levels of last dimension hierarchy. |
|
KeepParent | The KeepParent property determines whether owners of non-excluded elements are kept in the filtered table. |
|
SupressEmpty | The SupressEmpty property determines whether cells with empty values are filtered. |
|
SupressNoNumeric | The SuppressNoNumeric property determines whether cells with non-numeric values are filtered. |
|
SupressZeros | The SuppressZeros property determines whether cells with zero values are filtered. |
|
UseAdditionalTableSource | The UseAdditionalTableSource property determines whether filtering by additional selection that is different from that in the data source is used. |
|
The UseAttributesLinks property returns whether filtering by dimension attribute links is used. |
|
|
UseCondition | The UseCondition property determines whether data filtering by condition is used in table. |
|
UseTransformationFilter | The UseTransformationFilter property determines whether data filtering by formula is used. |
See also: