PivotGridOptionsViewBase.ShowColumnGrandTotals Property

Gets or sets whether to display column Grand Totals.

Namespace: DevExpress.XtraPivotGrid

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

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

Declaration

C#

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

VB.NET

<DefaultValue(True)>
Public Property ShowColumnGrandTotals As Boolean

Property Value

Type	Default	Description
Boolean	true	true to display column Grand Totals; otherwise, false.

Remarks

Note that Grand Totals can’t be hidden if there is nothing else shown in the same area.

Related GitHub Examples

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

web-forms-pivot-grid-hide-particular-rows-and-columns/CS/ASPxPivotGrid_HidingColumnsAndRows/Data.cs#L33

pivot.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Near;
pivot.OptionsView.ShowColumnGrandTotals = false;
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far;

winforms-pivot-customize-appearance-of-the-even-odd-groups-of-cells/CS/WindowsApplication53/Form1.cs#L19

    pivotGridControl1.BestFit();
    pivotGridControl1.OptionsView.ShowColumnGrandTotals = false;
}

VB.NET

web-forms-pivot-grid-hide-particular-rows-and-columns/VB/ASPxPivotGrid_HidingColumnsAndRows/Data.vb#L46

pivot.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Near
pivot.OptionsView.ShowColumnGrandTotals = False
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far

winforms-pivot-customize-appearance-of-the-even-odd-groups-of-cells/VB/WindowsApplication53/Form1.vb#L22

    pivotGridControl1.BestFit()
    pivotGridControl1.OptionsView.ShowColumnGrandTotals = False
End Sub