Skip to main content

PivotGridGroup.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 group, 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 group, new field values are always displayed, regardless of the ShowNewValues property value.

The ShowNewValues property is also not in effect if hierarchical filtering is disabled for the current group (see PivotGridFieldOptions.GroupFilterMode). In this instance, use the PivotGridFieldBase.ShowNewValues properties of individual fields.


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.

See Also