Back to Devexpress

PivotGridOptionsViewBase.ShowColumnGrandTotals Property

corelibraries-devexpress-dot-xtrapivotgrid-dot-pivotgridoptionsviewbase-00fd381f.md

latest4.2 KB
Original Source

PivotGridOptionsViewBase.ShowColumnGrandTotals Property

Gets or sets whether to display column Grand Totals.

Namespace : DevExpress.XtraPivotGrid

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

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

Declaration

csharp
[DefaultValue(true)]
public bool ShowColumnGrandTotals { get; set; }
vb
<DefaultValue(True)>
Public Property ShowColumnGrandTotals As Boolean

Property Value

TypeDefaultDescription
Booleantrue

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.

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.

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

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

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

csharp
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

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

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

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

See Also

ShowRowGrandTotals

ShowGrandTotalsForSingleValues

ShowGrandTotal

PivotGridOptionsViewBase Class

PivotGridOptionsViewBase Members

DevExpress.XtraPivotGrid Namespace