PivotGridFieldOptions.ShowGrandTotal Property

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

Namespace : DevExpress.XtraPivotGrid

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

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

Declaration

• C#
• VB.NET

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

<DefaultValue(True)>
Public Property ShowGrandTotal As Boolean

Property Value

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

|

Property Paths

You can access this nested property as listed below:

.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#
• VB.NET

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;
}

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

See Also

ShowTotals

ShowValues

ShowColumnGrandTotals

ShowRowGrandTotals

ShowGrandTotalsForSingleValues

PivotGridFieldOptions Class

PivotGridFieldOptions Members

DevExpress.XtraPivotGrid Namespace