PivotGridFieldOptions.ShowGrandTotal Property

Gets or sets whether grand totals that correspond to the current data field are visible.

Namespace: DevExpress.XtraPivotGrid

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

Declaration

C#

[DefaultValue(true)]
public bool ShowGrandTotal { get; set; }

VB.NET

<DefaultValue(True)>
Public Property ShowGrandTotal As Boolean

Property Value

Type	Default	Description
Boolean	**true**	true if corresponding grand totals are visible; otherwise, false.

Property Paths

You can access this nested property as listed below:

Library	Object Type	Path to ShowGrandTotal
Cross-Platform Class Library	PivotGridFieldBase	.Options.ShowGrandTotal
WinForms Controls	PivotGridField	.Options.ShowGrandTotal
ASP.NET Controls and MVC Extensions	PivotGridField	.Options.ShowGrandTotal
	MVCxPivotGridField	.Options.ShowGrandTotal
Reporting	XRPivotGridField	.Options.ShowGrandTotal

Remarks

Use the PivotGridOptionsViewBase.ShowColumnGrandTotals, PivotGridOptionsViewBase.ShowRowGrandTotals and PivotGridOptionsViewBase.ShowGrandTotalsForSingleValues properties to control the visibility of grand totals for all fields.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the ShowGrandTotal 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.

C#

how-to-display-the-difference-of-income-and-outlay-in-totals-t413352/CS/PivotGridCustomSummaryExample/Form1.cs#L71

pivotGridControl1.Fields["Value"].Options.ShowTotals = false;
pivotGridControl1.Fields["Value"].Options.ShowGrandTotal = false;
// Create a new field to display totals.

pivot-grid-aggr-examples/CS/Pivot-Aggr-Examples/CodeFiles/CodeExample.cs#L105

percentOfTotal.Options.ShowTotals = false;
percentOfTotal.Options.ShowGrandTotal = false;
pivotGrid.Fields.Add(percentOfTotal);

VB.NET

how-to-display-the-difference-of-income-and-outlay-in-totals-t413352/VB/PivotGridCustomSummaryExample/Form1.vb#L57

pivotGridControl1.Fields("Value").Options.ShowTotals = False
pivotGridControl1.Fields("Value").Options.ShowGrandTotal = False
' Create a new field to display totals.

pivot-grid-aggr-examples/VB/Pivot-Aggr-Examples/CodeFiles/CodeExample.vb#L98

percentOfTotal.Options.ShowTotals = False
percentOfTotal.Options.ShowGrandTotal = False
pivotGrid.Fields.Add(percentOfTotal)