Assembly: Pivot;
The IPivotFilter interface contains properties that determine data filtering parameters.
IPivotFilter
Data filtering parameters can be set by means of the FilterSetup command of the Express plugin.
| Property name | Brief description | |
 |
Area | The Area property determines the area, to which data filtering is applied. |
|
Elements | The Elements property determines the table element, by which filtering is executed. |
|
Range | The Range property returns the range, in which data filtering is executed. |
|
SeparateHeaders | The SeparateHeaders property determines whether filtering settings are used separately for rows and columns. |
| 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: