PivotGridOptionsChartDataSourceBase.ProvideRowGrandTotals Property

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

Namespace: DevExpress.XtraPivotGrid.Data

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

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Dashboard.Design

Declaration

C#

[DefaultValue(false)]
public virtual bool ProvideRowGrandTotals { get; set; }

VB.NET

<DefaultValue(False)>
Public Overridable Property ProvideRowGrandTotals As Boolean

Property Value

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

Remarks

In the following image, a chart control creates series for selected PivotGrid columns (the PivotGridOptionsChartDataSourceBase.ProvideDataByColumns property is set to true). The ProvideRowGrandTotals property is set to true, and the PivotGrid’s “Grand Total” row data is passed to a chart control:

If the ProvideRowGrandTotals property is set to false, the PivotGrid’s “Grand Total” row data is not passed to a chart control:

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 ProvideRowGrandTotals 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#L95

(!fPivot.OptionsChartDataSource.ProvideRowCustomTotals && cell.RowValueType == PivotGridValueType.CustomTotal) ||
(!fPivot.OptionsChartDataSource.ProvideRowGrandTotals && cell.RowValueType == PivotGridValueType.GrandTotal) ||
(!fPivot.OptionsChartDataSource.ProvideRowTotals && cell.RowValueType == PivotGridValueType.Total);

VB.NET

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

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