PivotGridOptionsViewBase.ShowGrandTotalsForSingleValues Property

Gets or sets whether grand totals are displayed when the control lists a single value of an outer column field or row field along its left or top edge.

Namespace: DevExpress.XtraPivotGrid

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

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

Declaration

C#

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

VB.NET

<DefaultValue(False)>
Public Property ShowGrandTotalsForSingleValues As Boolean

Property Value

Type	Default	Description
Boolean	false	true if the grand totals are always displayed; false if they are only displayed when the XtraPivotGrid displays two or more values of an outer column (or row) field along its top (or left) edge.

Remarks

The following image shows a sample XtraPivotGrid control whose ShowGrandTotalsForSingleValues property is set to false:

For the outer ‘Order Date’ column field the control lists a single value (1994). Therefore the column grand total is not displayed. The row grand total is visible since the control displays two values of the outer row field (‘Product Alphabetical’).

The following image shows the same control whose ShowGrandTotalsForSingleValues property is set to true:

Now the column grand total is visible and it duplicates information from the preceding column.