corelibraries-devexpress-dot-xtrapivotgrid-dot-pivotgridoptionsviewbase.md
Gets or sets the totals’ and grand totals’ location.
Namespace : DevExpress.XtraPivotGrid
Assembly : DevExpress.PivotGrid.v25.2.Core.dll
NuGet Packages : DevExpress.PivotGrid.Core, DevExpress.Win.Navigation
[DefaultValue(PivotRowTotalsLocation.Far)]
public PivotRowTotalsLocation RowTotalsLocation { get; set; }
<DefaultValue(PivotRowTotalsLocation.Far)>
Public Property RowTotalsLocation As PivotRowTotalsLocation
| 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.
|
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.
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.
winforms-pivot-grid-hide-specific-columns-and-rows/CS/Data.cs#L31
}
pivot.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Near;
pivot.OptionsView.ShowRowGrandTotals = false;
winforms-pivot-split-field-value-cells/CS/Data.cs#L30
}
pivot.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Far;
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far;
winforms-pivot-grid-hide-empty-columns-and-rows/CS/Data.cs#L31
//}
pivot.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Far;
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far;
web-forms-pivot-grid-split-field-value-cells/CS/ASPxPivotGrid_SplittingCells/Data.cs#L31
}
pivot.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Far;
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far;
}
pivot.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Near;
pivot.OptionsView.ShowColumnGrandTotals = false;
winforms-pivot-grid-hide-specific-columns-and-rows/VB/Data.vb#L35
Next field
pivot.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Near
pivot.OptionsView.ShowRowGrandTotals = False
winforms-pivot-split-field-value-cells/VB/Data.vb#L34
Next field
pivot.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Far
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far
winforms-pivot-grid-hide-empty-columns-and-rows/VB/Data.vb#L43
'}
pivot.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Far
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far
web-forms-pivot-grid-split-field-value-cells/VB/ASPxPivotGrid_SplittingCells/Data.vb#L44
pivot.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Far
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far
pivot.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Near
pivot.OptionsView.ShowColumnGrandTotals = False
See Also
PivotGridOptionsViewBase Class