MVCxPivotGridWebOptionsData.AllowCrossGroupVariation Property

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

Namespace: DevExpress.Web.Mvc

Assembly: DevExpress.Web.Mvc5.v23.2.dll

NuGet Package: DevExpress.Web.Mvc5

Declaration

C#

public bool AllowCrossGroupVariation { get; set; }

VB.NET

Public Property AllowCrossGroupVariation As Boolean

Property Value

Type	Description
Boolean	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:

Object Type	Path to 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 “AbsoluteVariation” data field. The AllowCrossGroupVariation property is set to false, so the summary variations for the cells within the group “Year=1996” are calculated independently from the previous group “Year=1995”. Note the row “Year=1996, Qtr=1, AbsoluteVariation” is empty.

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