CubeField.IncludeNewItemsInFilter Property (Excel)

The IncludeNewItemsInFilter property is used to track included/excluded items in OLAP PivotTables. Read/write.

Syntax

expression. IncludeNewItemsInFilter

expression A variable that represents a CubeField object.

Remarks

Default value is False .

When this setting is set to True , excluded items are tracked when manual filtering is applied. When this setting is set to False , included items are tracked when manual filtering is applied.

When IncludeNewItemsInFilter is set to False , the HiddenItemsList and HiddenItems collections are empty and items cannot be added to them.

When IncludeNewItemsInFilter is set to True , the VisibleItemsList and VisibleItems collections are empty and items cannot be added to them.

See also

CubeField Object