PivotRowTotalsLocation Enum

Lists values that specify the location of the row and grand totals.

Namespace: DevExpress.XtraPivotGrid

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

Declaration

C#

[TypeConverter(typeof(EnumTypeConverter))]
[ResourceFinder(typeof(ResFinder), "PropertyNamesRes")]
public enum PivotRowTotalsLocation

VB.NET

<ResourceFinder(GetType(ResFinder), "PropertyNamesRes")>
<TypeConverter(GetType(EnumTypeConverter))>
Public Enum PivotRowTotalsLocation

Members

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.

Related API Members

The following properties accept/return PivotRowTotalsLocation values:

• PivotGridOptionsViewBase.RowTotalsLocation

Remarks

The values listed by this enumeration are used to set the PivotGridOptionsViewBase.RowTotalsLocation property.

Related GitHub Examples

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

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.

C#

how-to-hide-particular-rows-and-columns-e2767/CS/ASPxPivotGrid_HidingColumnsAndRows/Data.cs#L32

}
pivot.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Near;
pivot.OptionsView.ShowColumnGrandTotals = false;

how-to-locate-field-value-cells-matching-a-particular-condition-e2770/CS/ASPxPivotGrid_FindCells/Data.cs#L32

}
pivot.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Far;
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far;

how-to-split-field-value-cells-e2762/CS/ASPxPivotGrid_SplittingCells/Data.cs#L31

}
pivot.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Far;
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far;

how-to-hide-empty-field-values-columns-rows-e2807/CS/Data.cs#L54

//}
pivot.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Far;
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far;

how-to-hide-particular-rows-and-columns-e2769/CS/Data.cs#L31

}
pivot.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Near;
pivot.OptionsView.ShowRowGrandTotals = false;

VB.NET

how-to-hide-particular-rows-and-columns-e2767/VB/ASPxPivotGrid_HidingColumnsAndRows/Data.vb#L36

Next field
pivot.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Near
pivot.OptionsView.ShowColumnGrandTotals = False

how-to-locate-field-value-cells-matching-a-particular-condition-e2770/VB/ASPxPivotGrid_FindCells/Data.vb#L35

Next field
pivot.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Far
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far

how-to-split-field-value-cells-e2762/VB/ASPxPivotGrid_SplittingCells/Data.vb#L34

Next field
pivot.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Far
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far

how-to-hide-empty-field-values-columns-rows-e2807/VB/Data.vb#L58

'}
pivot.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Far
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far

how-to-hide-particular-rows-and-columns-e2769/VB/Data.vb#L35

Next field
pivot.OptionsView.RowTotalsLocation = PivotRowTotalsLocation.Near
pivot.OptionsView.ShowRowGrandTotals = False