PivotGridOptionsViewBase.RowTotalsLocation Property

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

Namespace: DevExpress.XtraPivotGrid

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


public PivotRowTotalsLocation RowTotalsLocation { get; set; }
Public Property RowTotalsLocation As PivotRowTotalsLocation

Property Value

Type Default Description


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

Property Paths

You can access this nested property as listed below:

Library Object Type Path to RowTotalsLocation
WinForms Controls PivotGridControl
ASP.NET Controls and MVC Extensions ASPxPivotGrid
Reporting XRPivotGrid


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.


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

See Also