Assembly: Pivot;
Namespace: Prognoz.Platform.Interop.Pivot;
The IPivotFilter interface contains properties that define parameters of data filtering.
IPivotFilter
Data filtering parameters can be set by means of the FilterSetup command of the Express plugin.
| Property name | Brief description | |
| The Area property determines an area, to which data filtering is applied. | ||
| The Elements property determines a table element, according to which the filtering is performed. | ||
| The Range property returns a range, in which the data is filtered. | ||
| The SeparateHeaders property determines whether filtering settings are used separately for rows and columns. |
| Property name | Brief description | |
| AttributeLinks | The AttributeLinks property returns filtering parameters by dimension attributes links. | |
| Condition | The Condition property determines filtering expression parameters. | |
| ConditionType | The ConditionType property determines a condition type, according to which the 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. | |
| 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 remain 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. | |
| 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: