Skip to main content

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.v22.1.Core.dll


public bool ShowGrandTotalsForSingleValues { get; set; }

Property Value

Type Default Description


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
Reporting XRPivotGrid
ASP.NET MVC Extensions MVCxPivotGrid
ASP.NET Web Forms Controls ASPxPivotGrid


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.

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the ShowGrandTotalsForSingleValues property.


The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

See Also