PivotGridFieldOptions.ShowGrandTotal Property

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

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v24.1.Core.dll

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

Declaration

C#

[TypeConverter(typeof(BooleanTypeConverter))]
[XtraSerializableProperty]
public bool ShowGrandTotal { get; set; }

VB.NET

<XtraSerializableProperty>
<TypeConverter(GetType(BooleanTypeConverter))>
Public Property ShowGrandTotal As Boolean

Property Value

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

Property Paths

You can access this nested property as listed below:

Object Type	Path to ShowGrandTotal
PivotGridFieldBase	.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#

winforms-pivotgrid--display-the-difference-of-income-and-outlay-in-totals/CS/PivotGridCustomSummaryExample/Form1.cs#L71

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

winforms-pivot-grid-custom-aggregates/CS/Win_Pivot_CustomAggregates/Form1.cs#L25

    pivotGridField1.Options.ShowExpressionEditorMenu = true;
    pivotGridField1.Options.ShowGrandTotal = false;
}

VB.NET

winforms-pivotgrid--display-the-difference-of-income-and-outlay-in-totals/VB/PivotGridCustomSummaryExample/Form1.vb#L57

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

winforms-pivot-grid-custom-aggregates/VB/Win_Pivot_CustomAggregates/Form1.vb#L25

    pivotGridField1.Options.ShowExpressionEditorMenu = True
    pivotGridField1.Options.ShowGrandTotal = False
End Sub