IPivotFilterSettings.UseAdditionalTableSource

Syntax

UseAdditionalTableSource: Boolean;

Description

The UseAdditionalTableSource property determines whether filtering by additional selection that is different from that in the data source is used.

Comments

Available values:

True. Filtering by additional selection is used.
False. Filtering by additional selection is not used.

The additional selection allows for filtering not by the data displayed in the table but by the data in this selection. The selection can be changed by any dimension. If the additional selection does not have the selection for any dimension, the dimension's selection determined in the data source is used. The dimension with the Metric role can have only a single selection. If aggregation settings are determined for fixed dimension, one can determine multiple selection for them.

Filtering by additional selection is available for the following filtering types:

Hide empty cells.
Hide cells with zero values.
Hide cells with non-numeric values.
By attribute links.

If a table is built on several data sources, and an additional selection is set for one of the data sources, filtering is applied to common dimensions of all data sources and fixed dimensions of the data source, for which the additional selection is set.

Example

The property use is given in the example for IPivotFilterSettings.AdditionalTableSourceSelSet.