Skip to main content

PivotGridOptionsViewBase.RowTotalsLocation Property

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

Namespace: DevExpress.XtraPivotGrid

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

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Navigation


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

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



Row Totals are displayed under the row field values.



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



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.

The following code snippets (auto-collected from DevExpress Examples) contain references to the RowTotalsLocation property.


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.

See Also