IPivotFilterSettings.KeepParent

Syntax

KeepParent: Boolean;

Description

The KeepParent property determines whether owners of non-excluded elements remain in the filtered table.

Comments

Available values:

True. Owners of non-excluded elements remain in the filtered table.
False. Default value. Owners of non-excluded elements do not remain in the filtered table.

Setting this option enables the user to keep the owners of elements that do not satisfy the filtering condition in the filtered table even if their own values satisfy the filtering condition.

To use the property, set the IPivotFilterSettings.Enabled property to True.

Example

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