IPivotFilterSettings.KeepNeighbors

Syntax

KeepNeighbors: Boolean;

Description

The KeepNeighbors property determines whether data is filtered by levels of last dimension hierarchy.

Comments

Available values:

True. Data is filtered by last dimension hierarchy levels.
False. Default value. Data is not filtered.

If at least one element is not filtered in the heading or sidehead of the last dimension hierarchy level, the entire level, to which this element belongs, is not filtered.

Filtering example:

KeepNeighbors = True:

KeepNeighbors = False:

Example

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