PivotGridDataSourceOptions.RetrieveColumnGrandTotals Property

Specifies whether or not column grand 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 RetrieveColumnGrandTotals { get; set; }

VB.NET

Public Property RetrieveColumnGrandTotals As Boolean

Property Value

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

Property Paths

You can access this nested property as listed below:

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

Remarks

The RetrieveColumnGrandTotals property is linked together with the PivotGridOptionsChartDataSourceBase.ProvideColumnGrandTotals property of the associated Pivot Grid.

Use the PivotGridDataSourceOptions.RetrieveColumnTotals, 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 RetrieveColumnGrandTotals property returns false when attempting to get its value.

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