PivotGridOptionsData.AllowCrossGroupVariation Property

Gets or sets whether summary variations and running totals are calculated independently within individual groups, or throughout the Pivot Grid.

Namespace: DevExpress.XtraPivotGrid

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

Declaration

C#

[DefaultValue(true)]
[XtraSerializableProperty]
public bool AllowCrossGroupVariation { get; set; }

VB.NET

<DefaultValue(True)>
<XtraSerializableProperty>
Public Property AllowCrossGroupVariation As Boolean

Property Value

Type	Default	Description
Boolean	**true**	true to calculate summary variations and running totals throughout the Pivot Grid; false to calculate them independently within individual groups.

Property Paths

You can access this nested property as listed below:

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

Remarks

The summary variation feature can be enabled via the PivotGridFieldBase.SummaryDisplayType property. To enable running totals, use the PivotGridFieldBase.RunningTotal property.

In the image below, absolute summary variations are calculated for the “Profit (var)” data field. The AllowCrossGroupVariation property is set to false, so the summary variations for the cells within the group “Year=1995” are calculated independently from the previous group “Year=1994”. Note the column “Year=1995, Qtr=1, Profit (var)” is empty.

If the AllowCrossGroupVariation property is set to true, summary variations in the group “Year=1995” are calculated taking into account values of the previous group “Year=1994”.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the AllowCrossGroupVariation 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#

aspxpivotgrid-how-to-change-the-summary-display-mode-t590012/CS/SummaryDisplayMode/Default.aspx.cs#L163

protected void cbAllowCrossGroupVariation_CheckedChanged(object sender, EventArgs e) {
    pivotGrid.OptionsData.AllowCrossGroupVariation = cbAllowCrossGroupVariation.Checked;
}

aspxpivotgrid-how-to-calculate-running-totals-t590001/CS/RunningTotal/Default.aspx.cs#L7

    ASPxPivotGrid1.Fields["fieldQuarter"].RunningTotal = cbRunningTotals.Checked;
    ASPxPivotGrid1.OptionsData.AllowCrossGroupVariation = cbAllowCrossGroupRunningTotals.Checked;
}

VB.NET

aspxpivotgrid-how-to-change-the-summary-display-mode-t590012/VB/SummaryDisplayMode/Default.aspx.vb#L181

Protected Sub cbAllowCrossGroupVariation_CheckedChanged(ByVal sender As Object, ByVal e As EventArgs)
    pivotGrid.OptionsData.AllowCrossGroupVariation = cbAllowCrossGroupVariation.Checked
End Sub

aspxpivotgrid-how-to-calculate-running-totals-t590001/VB/RunningTotal/Default.aspx.vb#L9

    ASPxPivotGrid1.Fields("fieldQuarter").RunningTotal = cbRunningTotals.Checked
    ASPxPivotGrid1.OptionsData.AllowCrossGroupVariation = cbAllowCrossGroupRunningTotals.Checked
End Sub