Back to Devexpress

PivotGridOptionsViewBase.ShowGrandTotalsForSingleValues Property

corelibraries-devexpress-dot-xtrapivotgrid-dot-pivotgridoptionsviewbase-249f5d83.md

latest3.3 KB
Original Source

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

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

Declaration

csharp
[DefaultValue(false)]
public bool ShowGrandTotalsForSingleValues { get; set; }
vb
<DefaultValue(False)>
Public Property ShowGrandTotalsForSingleValues As Boolean

Property Value

TypeDefaultDescription
Booleanfalse

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.

See Also

ShowTotalsForSingleValues

ShowColumnGrandTotals

ShowRowGrandTotals

ShowGrandTotal

ShowColumnGrandTotalHeader

ShowRowGrandTotalHeader

PivotGridOptionsViewBase Class

PivotGridOptionsViewBase Members

DevExpress.XtraPivotGrid Namespace