Skip to main content

PivotGridFieldBase.ShowNewValues Property

Gets or sets whether field values that have appeared in the datasource after the field’s filtering was configured should be shown.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v22.2.Core.dll

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Dashboard.Design


public bool ShowNewValues { get; set; }

Property Value

Type Default Description
Boolean true

true to show new field values; otherwise, false.


If filtering is applied to the current field, the ShowNewValues property specifies whether new field values (values that have been added to the datasource after the filter condition was set) are shown or hidden by default.

If filtering is not applied to the field, new field values are always displayed, regardless of the ShowNewValues property value.

The ShowNewValues property is also not in effect if the current field is a part of a field group that uses a hierarchical filter (see PivotGridFieldOptions.GroupFilterMode). In this instance, use the group’s PivotGridGroup.ShowNewValues property.


The ShowNewValues property internally sets the filter type. The true value corresponds to the PivotFilterType.Excluded filter type, while the false value corresponds to the PivotFilterType.Included filter type.

In Pivot Grid, end-users can enable or disable the ShowNewValues option via the Toolbar_FilterType toolbar button.

Note that if the ShowNewValues property is set at design time, all filter values will be unchecked on the first load. To avoid this behavior, set the ShowNewValues property after data binding.

See Also