.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

PivotField.IncludeNewItemsInFilter Property

Gets or sets a value indicating whether new items should appear in the field when manual filtering is applied to it.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v21.2.Core.dll


bool IncludeNewItemsInFilter { get; set; }

Property Value

Type Description

true, to include new items in a manual filter; otherwise, false.

The default is false.


If you apply manual filtering to a PivotTable field to show data for specific field items and then add new records to the report’s data source, new items may appear in the pivot table after the refresh operation which are not included in the filter by default. However, it can be useful to display new data in the pivot table even if they do not match the filter criteria. To show new items in the manually filtered field, set the field’s IncludeNewItemsInFilter property to true.

See Also