PivotGridOptionsViewBase.RowTotalsLocation Property

Gets or sets the totals’ and grand totals’ location.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v21.1.Core.dll

Declaration

[DefaultValue(PivotRowTotalsLocation.Far)]
public PivotRowTotalsLocation RowTotalsLocation { get; set; }

Property Value

Type Default Description
PivotRowTotalsLocation

Far

A PivotRowTotalsLocation enumeration value which specifies the totals’ and grand totals’ location.

Available values:

Name Description
Near

Row Totals and Grand Totals are displayed above the row field values.

PivotRowTotalsLocation.Near

Far

Row Totals are displayed under the row field values.

PivotRowTotalsLocation.Far

Tree

Row Totals are displayed in a compact tree-like layout view.

PivotRowTotalsLocation.Tree

Property Paths

You can access this nested property as listed below:

Library Object Type Path to RowTotalsLocation
WinForms Controls PivotGridControl
.OptionsView.RowTotalsLocation
Reporting XRPivotGrid
.OptionsView.RowTotalsLocation
ASP.NET MVC Extensions MVCxPivotGrid
.OptionsView.RowTotalsLocation
PivotGridSettings
.OptionsView.RowTotalsLocation
ASP.NET Web Forms Controls ASPxPivotGrid
.OptionsView.RowTotalsLocation

Remarks

Use the RowTotalsLocation and PivotGridOptionsViewBase.ColumnTotalsLocation properties to specify the position of Row Totals, Column Totals and Grand Totals. To simultaneously set both RowTotalsLocation and ColumnTotalsLocation properties, the PivotGridOptionsViewBase.SetBothTotalsLocation method can be used.

Note that if the RowTotalsLocation property is set to PivotRowTotalsLocation.Tree, the PivotGridOptionsViewBase.ShowRowTotals and PivotGridOptionsViewBase.ShowTotalsForSingleValues properties can’t be set to False, and must remain True.

NOTE

The row fields’ PivotGridFieldOptions.ShowTotals and PivotGridFieldBase.TotalsVisibility properties are ignored when the RowTotalsLocation property is set to PivotRowTotalsLocation.Tree.

See Also