Variation Types

• Oct 15, 2023
• 3 minutes to read

Variation summary display types are designed to display absolute and percentage difference between the current value and the previously calculated value for the field. To employ variation summary display types, use DifferenceBinding in Optimized mode.

The following variation types are available:

Absolute Variation

The absolute variance between the current value and the previously calculated value for the current field is displayed in a cell.

Example

View Example: PivotGrid for WPF - How to Change SummaryDisplayType in the Context Menu

The following code snippet shows how to calculate the absolute variances for the Value field cells:

HeaderMenuHelper.cs

static void itemClickEventHandler(object sender, ItemClickEventArgs e) {
    BarItem barItem = sender as BarItem;
    object[] barItemInfo = (object[])barItem.Tag;
    PivotGridField field = (PivotGridField)barItemInfo[0];
    FieldSummaryDisplayType newValue = (FieldSummaryDisplayType)barItemInfo[2];
    DataSourceColumnBinding sourceBinding = new DataSourceColumnBinding("Value");
    switch(newValue){
        case FieldSummaryDisplayType.AbsoluteVariation:
            field.DataBinding = new DifferenceBinding(
                sourceBinding,
                CalculationPartitioningCriteria.RowValue,
                CalculationDirection.DownThenAcross,
                DifferenceTarget.Previous,
                DifferenceType.Absolute);
            break;
            // ...
    }
    field.Tag = newValue;
    (field.Parent as PivotGridControl).ReloadData();
}

HeaderMenuHelper.vb

        Private Shared Sub itemClickEventHandler(ByVal sender As Object, ByVal e As ItemClickEventArgs)
            Dim barItem As BarItem = TryCast(sender, BarItem)
            Dim barItemInfo() As Object = CType(barItem.Tag, Object())
            Dim field As PivotGridField = DirectCast(barItemInfo(0), PivotGridField)
            Dim newValue As FieldSummaryDisplayType = DirectCast(barItemInfo(2), FieldSummaryDisplayType)
            Dim sourceBinding As New DataSourceColumnBinding("Value")
            Select Case newValue
                Case FieldSummaryDisplayType.AbsoluteVariation
                    field.DataBinding = New DifferenceBinding(sourceBinding, CalculationPartitioningCriteria.RowValue, CalculationDirection.DownThenAcross, DifferenceTarget.Previous, DifferenceType.Absolute)
                    ' ...
            End Select
            field.Tag = newValue
            TryCast(field.Parent, PivotGridControl).ReloadData()
        End Sub

Note

Set PivotGridField.SummaryDisplayType to AbsoluteVariation in Legacy and LegacyOptimized modes.

Percent Variation

The percentage variance between the current value and the previously calculated value for the current field is displayed in a cell.

Example

View Example: PivotGrid for WPF - How to Change SummaryDisplayType in the Context Menu

The following code snippet shows how to calculate the percent variances for the Value field cells:

HeaderMenuHelper.cs

static void itemClickEventHandler(object sender, ItemClickEventArgs e) {
    BarItem barItem = sender as BarItem;
    object[] barItemInfo = (object[])barItem.Tag;
    PivotGridField field = (PivotGridField)barItemInfo[0];
    FieldSummaryDisplayType newValue = (FieldSummaryDisplayType)barItemInfo[2];
    DataSourceColumnBinding sourceBinding = new DataSourceColumnBinding("Value");
    switch(newValue){
    // ...
        case FieldSummaryDisplayType.PercentVariation:
            field.DataBinding = new DifferenceBinding(
                sourceBinding,
                CalculationPartitioningCriteria.RowValue,
                CalculationDirection.DownThenAcross,
                DifferenceTarget.Previous,
                DifferenceType.Percentage);
            break;
            // ...
    }
    field.Tag = newValue;
    (field.Parent as PivotGridControl).ReloadData();
}

HeaderMenuHelper.vb

        Private Shared Sub itemClickEventHandler(ByVal sender As Object, ByVal e As ItemClickEventArgs)
            Dim barItem As BarItem = TryCast(sender, BarItem)
            Dim barItemInfo() As Object = CType(barItem.Tag, Object())
            Dim field As PivotGridField = DirectCast(barItemInfo(0), PivotGridField)
            Dim newValue As FieldSummaryDisplayType = DirectCast(barItemInfo(2), FieldSummaryDisplayType)
            Dim sourceBinding As New DataSourceColumnBinding("Value")
            Select Case newValue
            ' ...
                Case FieldSummaryDisplayType.PercentVariation
                    field.DataBinding = New DifferenceBinding(sourceBinding, CalculationPartitioningCriteria.RowValue, CalculationDirection.DownThenAcross, DifferenceTarget.Previous, DifferenceType.Percentage)
                    ' ...
            End Select
            field.Tag = newValue
            TryCast(field.Parent, PivotGridControl).ReloadData()
        End Sub

Note

Set PivotGridField.SummaryDisplayType to PercentVariation in Legacy and LegacyOptimized modes.