Skip to main content

PivotGridOptionsViewBase.ShowTotalsForSingleValues Property

Gets or sets whether automatic totals are displayed for the field values which contain a single nesting field value.

Namespace: DevExpress.XtraPivotGrid

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

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Navigation

#Declaration

[DefaultValue(false)]
public bool ShowTotalsForSingleValues { get; set; }

#Property Value

Type Default Description
Boolean false

true to display totals for any field value; false to display totals for the field values which fall into two or more categories.

#Remarks

When the ShowTotalsForSingleValues property is set to false totals are calculated and displayed against the field values which fall into two or more categories. If a field value doesn’t contain or contains a single nesting field value the corresponding total is not displayed. The following image shows a sample XtraPivotGrid control with the ShowTotalsForSingleValues property set to false:

ShowTotalsForSingleValues_False

In this image, the ‘Eastern Connection’ field value contains a single nesting field value (‘Camembert Pierrot’), so a corresponding row total is not displayed. The ‘Bottom Dollar Markets’ field value falls into two categories (‘Aniseed Syrup’ and ‘Camembert Pierrot’). Therefore the XtraPivotGrid control displays a row total for this field (‘Bottom-Dollar Markets Total’).

The following image shows the same XtraPivotGrid control with the ShowTotalsForSingleValues property set to true:

ShowTotalsForSingleValues_True

Now the row total for the ‘Eastern Connection’ field value is visible and it duplicates information from the preceding row.

See Also