PivotGridOptionsViewBase.ShowColumnGrandTotals Property

Gets or sets whether to display column Grand Totals.

Namespace: DevExpress.XtraPivotGrid

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

Declaration

C#

[DefaultValue(true)]
[XtraSerializableProperty]
[TypeConverter(typeof(BooleanTypeConverter))]
public bool ShowColumnGrandTotals { get; set; }

VB.NET

<DefaultValue(True)>
<XtraSerializableProperty>
<TypeConverter(GetType(BooleanTypeConverter))>
Public Property ShowColumnGrandTotals As Boolean

Property Value

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

Property Paths

You can access this nested property as listed below:

Library	Object Type	Path to ShowColumnGrandTotals
WinForms Controls	PivotGridControl	.OptionsView.ShowColumnGrandTotals
ASP.NET Controls and MVC Extensions	ASPxPivotGrid	.OptionsView.ShowColumnGrandTotals
	MVCxPivotGrid	.OptionsView.ShowColumnGrandTotals
	PivotGridSettings	.OptionsView.ShowColumnGrandTotals
Reporting	XRPivotGrid	.OptionsView.ShowColumnGrandTotals

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#

XAF_how-to-enable-runtime-pivotgrid-customization-pivot-chart-module-e1886/CS/PivotGridCustomization.Module.Win/PivotGridCustomizationDetailViewItem.cs#L42

    showRowGrandTotalCheckEdit.Checked = analysisEditor.Control.PivotGrid.OptionsView.ShowRowGrandTotals;
    showColumnGrandTotalCheckEdit.Checked = analysisEditor.Control.PivotGrid.OptionsView.ShowColumnGrandTotals;
}

XAF_how-to-make-pivotgridcontrol-editable-when-using-the-pivot-chart-analysis-module-e1232/CS/WinSample.Module.Win/PivotGridInplaceEditorsController.cs#L32

pivotGrid.OptionsView.ShowRowGrandTotals = false;
pivotGrid.OptionsView.ShowColumnGrandTotals = false;
pivotGrid.EditValueChanged += pivotGridControl_EditValueChanged;

how-to-hide-particular-rows-and-columns-e2767/CS/ASPxPivotGrid_HidingColumnsAndRows/Data.cs#L33

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

VB.NET

XAF_how-to-enable-runtime-pivotgrid-customization-pivot-chart-module-e1886/VB/PivotGridCustomization.Module.Win/PivotGridCustomizationDetailViewItem.vb#L45

    showRowGrandTotalCheckEdit.Checked = analysisEditor.Control.PivotGrid.OptionsView.ShowRowGrandTotals
    showColumnGrandTotalCheckEdit.Checked = analysisEditor.Control.PivotGrid.OptionsView.ShowColumnGrandTotals
End Sub

XAF_how-to-make-pivotgridcontrol-editable-when-using-the-pivot-chart-analysis-module-e1232/VB/WinSample.Module.Win/PivotGridInplaceEditorsController.vb#L34

pivotGrid.OptionsView.ShowRowGrandTotals = False
pivotGrid.OptionsView.ShowColumnGrandTotals = False
AddHandler pivotGrid.EditValueChanged, AddressOf pivotGridControl_EditValueChanged

how-to-hide-particular-rows-and-columns-e2767/VB/ASPxPivotGrid_HidingColumnsAndRows/Data.vb#L37

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

Reporting_how-to-create-custom-total-columns-in-xrpivotgrid-at-runtime-e1064/VB/PivotWithCustomColumnsAtRuntime/Form1.vb#L38

fieldTotalPrice.FieldName = "TotalPrice"
pivot.OptionsView.ShowColumnGrandTotals = False
pivot.Fields.AddRange(New XRPivotGridField() { fieldProductName, fieldUnitPrice, fieldOrderID, fieldQuantity, fieldTotalPrice })