corelibraries-devexpress-dot-xtrapivotgrid-dot-pivotgridoptionsviewbase-419ef8eb.md
Gets or sets the column totals’ location.
Namespace : DevExpress.XtraPivotGrid
Assembly : DevExpress.PivotGrid.v25.2.Core.dll
NuGet Packages : DevExpress.PivotGrid.Core, DevExpress.Win.Navigation
[DefaultValue(PivotTotalsLocation.Far)]
public PivotTotalsLocation ColumnTotalsLocation { get; set; }
<DefaultValue(PivotTotalsLocation.Far)>
Public Property ColumnTotalsLocation As PivotTotalsLocation
| Type | Default | Description |
|---|---|---|
| PivotTotalsLocation | Far |
A PivotTotalsLocation enumeration value which specifies the column totals’ location.
|
Available values:
| Name | Description |
|---|---|
| Near |
Column Totals are displayed to the left of the column field values.
| | Far |
Column Totals are displayed to the right of the column field values.
|
Use the PivotGridOptionsViewBase.RowTotalsLocation and ColumnTotalsLocation properties to specify the position of Row Totals, Column Totals and Grand Totals. To set both RowTotalsLocation and ColumnTotalsLocation properties simultaneously, the PivotGridOptionsViewBase.SetBothTotalsLocation method can be used.
The following code snippets (auto-collected from DevExpress Examples) contain references to the ColumnTotalsLocation 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-hide-specific-columns-and-rows/CS/Data.cs#L33
pivot.OptionsView.ShowRowGrandTotals = false;
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far;
pivot.OptionsDataField.Area = PivotDataArea.ColumnArea;
winforms-pivot-split-field-value-cells/CS/Data.cs#L31
pivot.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Far;
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far;
pivot.OptionsDataField.Area = PivotDataArea.ColumnArea;
winforms-pivot-grid-hide-empty-columns-and-rows/CS/Data.cs#L32
pivot.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Far;
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far;
pivot.OptionsDataField.Area = PivotDataArea.ColumnArea;
web-forms-pivot-grid-split-field-value-cells/CS/ASPxPivotGrid_SplittingCells/Data.cs#L32
pivot.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Far;
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far;
pivot.OptionsDataField.Area = PivotDataArea.ColumnArea;
pivot.OptionsView.ShowColumnGrandTotals = false;
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far;
pivot.OptionsDataField.Area = PivotDataArea.ColumnArea;
winforms-pivot-grid-hide-specific-columns-and-rows/VB/Data.vb#L37
pivot.OptionsView.ShowRowGrandTotals = False
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far
pivot.OptionsDataField.Area = PivotDataArea.ColumnArea
winforms-pivot-split-field-value-cells/VB/Data.vb#L35
pivot.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Far
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far
pivot.OptionsDataField.Area = PivotDataArea.ColumnArea
winforms-pivot-grid-hide-empty-columns-and-rows/VB/Data.vb#L44
pivot.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Far
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far
pivot.OptionsDataField.Area = PivotDataArea.ColumnArea
web-forms-pivot-grid-split-field-value-cells/VB/ASPxPivotGrid_SplittingCells/Data.vb#L45
pivot.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Far
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far
pivot.OptionsDataField.Area = PivotDataArea.ColumnArea
pivot.OptionsView.ShowColumnGrandTotals = False
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far
pivot.OptionsDataField.Area = PivotDataArea.ColumnArea
See Also
PivotGridOptionsViewBase Class