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.v18.2.Core.dll
Declaration
[DefaultValue(false)]
[XtraSerializableProperty]
[TypeConverter(typeof(BooleanTypeConverter))]
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 |
|
| ASP.NET Controls and MVC Extensions | ASPxPivotGrid |
|
| MVCxPivotGrid |
|
|
| PivotGridSettings |
|
|
| Reporting | XRPivotGrid |
|
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.
Related GitHub Examples
The following code snippet (auto-collected from DevExpress Examples) contains a reference to the ShowGrandTotalsForSingleValues property.
Note
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.