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
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.
|
| Far | Row Totals are displayed under the row field values.
|
| Tree | Row Totals are displayed in a compact tree-like layout view.
|
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.
Related GitHub Examples
The following code snippets (auto-collected from DevExpress Examples) contain references to the RowTotalsLocation 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.