PivotGridOptionsViewBase.ShowColumnTotals Property

Gets or sets whether to display column automatic Totals.

Namespace: DevExpress.XtraPivotGrid

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

Declaration

C#

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

VB.NET

<DefaultValue(True)>
Public Property ShowColumnTotals As Boolean

Property Value

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

Remarks

You can prevent automatic totals from being displayed for specific column and row fields. Set a field’s PivotGridFieldBase.TotalsVisibility property to PivotTotalsVisibility.CustomTotals to display custom totals instead of automatic totals. Set the PivotGridFieldBase.TotalsVisibility property to PivotTotalsVisibility.None to hide the totals.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the ShowColumnTotals 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-pivot-grid-custom-aggregates/CS/Win_Pivot_CustomAggregates/Form1.cs#L11

pivotGridControl1.BestFit();
pivotGridControl1.OptionsView.ShowColumnTotals = false;
pivotGridControl1.OptionsView.ShowRowTotals = false;

VB.NET

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

pivotGridControl1.BestFit()
pivotGridControl1.OptionsView.ShowColumnTotals = False
pivotGridControl1.OptionsView.ShowRowTotals = False