PivotGridDataSourceOptions.RetrieveColumnTotals Property

Specifies whether or not column totals should be passed to a Chart from its associated Pivot Grid.

Namespace: DevExpress.XtraCharts

Assembly: DevExpress.XtraCharts.v23.2.dll

NuGet Package: DevExpress.Charts

Declaration

C#

public bool RetrieveColumnTotals { get; set; }

VB.NET

Public Property RetrieveColumnTotals As Boolean

Property Value

Type	Description
Boolean	true to retrieve column totals; otherwise, false.

Property Paths

You can access this nested property as listed below:

Library	Object Type	Path to RetrieveColumnTotals
WinForms Controls	ChartControl	.PivotGridDataSourceOptions .RetrieveColumnTotals
Reporting	XRChart	.PivotGridDataSourceOptions .RetrieveColumnTotals
ASP.NET MVC Extensions	ChartControlSettings	.PivotGridDataSourceOptions .RetrieveColumnTotals
ASP.NET Web Forms Controls	WebChartControl	.PivotGridDataSourceOptions .RetrieveColumnTotals

Remarks

The RetrieveColumnTotals property is linked together with the PivotGridOptionsChartDataSourceBase.ProvideColumnTotals property of the associated Pivot Grid.

Use the RetrieveColumnTotals, PivotGridDataSourceOptions.RetrieveColumnGrandTotals and PivotGridDataSourceOptions.RetrieveColumnCustomTotals properties, to define whether a Pivot Grid’s column totals are reflected in a Chart.

Row totals are maintained by the PivotGridDataSourceOptions.RetrieveRowTotals, PivotGridDataSourceOptions.RetrieveRowGrandTotals and PivotGridDataSourceOptions.RetrieveRowCustomTotals properties.

Note

If the Chart’s data source is not a Pivot Grid, trying to set this property causes a NotSupportedException, and the RetrieveColumnTotals property returns false when attempting to get its value.

For more information, see Pivot Charting (Integration with a Pivot Grid Control).