corelibraries-devexpress-dot-xtrapivotgrid-dot-pivotgridoptionsviewbase-6008d236.md
Gets or sets whether to display column automatic Totals.
Namespace : DevExpress.XtraPivotGrid
Assembly : DevExpress.PivotGrid.v25.2.Core.dll
NuGet Packages : DevExpress.PivotGrid.Core, DevExpress.Win.Navigation
[DefaultValue(true)]
public bool ShowColumnTotals { get; set; }
<DefaultValue(True)>
Public Property ShowColumnTotals As Boolean
| Type | Default | Description |
|---|---|---|
| Boolean | true |
true to display column automatic Totals; otherwise, false.
|
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.
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.
winforms-pivot-grid-custom-aggregates/CS/Win_Pivot_CustomAggregates/Form1.cs#L11
pivotGridControl1.BestFit();
pivotGridControl1.OptionsView.ShowColumnTotals = false;
pivotGridControl1.OptionsView.ShowRowTotals = false;
winforms-pivot-grid-custom-aggregates/VB/Win_Pivot_CustomAggregates/Form1.vb#L12
pivotGridControl1.BestFit()
pivotGridControl1.OptionsView.ShowColumnTotals = False
pivotGridControl1.OptionsView.ShowRowTotals = False
See Also
PivotGridOptionsViewBase Class