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.v20.2.Core.dll

Declaration

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

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.

Property Paths

You can access this nested property as listed below:

Library Object Type Path to ShowGrandTotalsForSingleValues
WinForms Controls PivotGridControl
.OptionsView.ShowGrandTotalsForSingleValues
Reporting XRPivotGrid
.OptionsView.ShowGrandTotalsForSingleValues
ASP.NET MVC Extensions MVCxPivotGrid
.OptionsView.ShowGrandTotalsForSingleValues
PivotGridSettings
.OptionsView.ShowGrandTotalsForSingleValues
ASP.NET Web Forms Controls ASPxPivotGrid
.OptionsView.ShowGrandTotalsForSingleValues

Remarks

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

ShowGrandTotalsForSingleValues_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:

ShowGrandTotalsForSingleValues_True

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

See Also