PivotGridOptionsChartDataSourceBase.ProvideColumnTotals Property

Gets or sets whether column totals are passed to a chart control.

Namespace: DevExpress.XtraPivotGrid.Data

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

Declaration

C#

[DefaultValue(false)]
[XtraSerializableProperty(-100)]
public virtual bool ProvideColumnTotals { get; set; }

VB.NET

<DefaultValue(False)>
<XtraSerializableProperty(-100)>
Public Overridable Property ProvideColumnTotals As Boolean

Property Value

Type	Default	Description
Boolean	**false**	true if column totals are displayed in a chart control; otherwise, false.

Property Paths

You can access this nested property as listed below:

Library	Object Type	Path to ProvideColumnTotals
WinForms Controls	PivotGridControl	.OptionsChartDataSource.ProvideColumnTotals
Reporting	XRPivotGrid	.OptionsChartDataSource.ProvideColumnTotals
ASP.NET Web Forms Controls	ASPxPivotGrid	.OptionsChartDataSource.ProvideColumnTotals
	MVCxPivotGrid	.OptionsChartDataSource.ProvideColumnTotals
	PivotGridSettings	.OptionsChartDataSource.ProvideColumnTotals

Remarks

In the following image, a chart control creates series for selected PivotGrid columns (the PivotGridOptionsChartDataSourceBase.ProvideDataByColumns property is set to true). The ProvideColumnTotals property is set to true, and a series representing the “1994 Total” column is created in a chart control:

If the ProvideColumnTotals property is set to false, a series for the “1994 Total” column is not created:

Note

This property is in effect when PivotGridOptionsChartDataSourceBase.DataProvideMode is set to PivotChartDataProvideMode.UseCustomSettings.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the ProvideColumnTotals 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.

C#

how-to-create-a-custom-chart-data-source-e2520/CS/CustomChartDataSourceWin/CustomChartDataSource.cs#L93

(!fPivot.OptionsChartDataSource.ProvideColumnGrandTotals && cell.ColumnValueType == PivotGridValueType.GrandTotal) ||
(!fPivot.OptionsChartDataSource.ProvideColumnTotals && cell.ColumnValueType == PivotGridValueType.Total) ||
(!fPivot.OptionsChartDataSource.ProvideRowCustomTotals && cell.RowValueType == PivotGridValueType.CustomTotal) ||

VB.NET

how-to-create-a-custom-chart-data-source-e2520/VB/CustomChartDataSourceWin/CustomChartDataSource.vb#L99

Private Function SkipCellValue(ByVal cell As PivotCellEventArgs) As Boolean
    Return ((Not fPivot.OptionsChartDataSource.ProvideColumnCustomTotals) AndAlso cell.ColumnValueType = PivotGridValueType.CustomTotal) OrElse ((Not fPivot.OptionsChartDataSource.ProvideColumnGrandTotals) AndAlso cell.ColumnValueType = PivotGridValueType.GrandTotal) OrElse ((Not fPivot.OptionsChartDataSource.ProvideColumnTotals) AndAlso cell.ColumnValueType = PivotGridValueType.Total) OrElse ((Not fPivot.OptionsChartDataSource.ProvideRowCustomTotals) AndAlso cell.RowValueType = PivotGridValueType.CustomTotal) OrElse ((Not fPivot.OptionsChartDataSource.ProvideRowGrandTotals) AndAlso cell.RowValueType = PivotGridValueType.GrandTotal) OrElse ((Not fPivot.OptionsChartDataSource.ProvideRowTotals) AndAlso cell.RowValueType = PivotGridValueType.Total)
End Function