Variation Types

• Oct 08, 2023
• 2 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: Pivot Grid for Web Forms - How to Change the Summary Display Mode

The following code snippet shows how to calculate the absolute variances for the Pivot Grid cells:

Default.aspx.cs

void SetSelectedSummaryDisplayType() {
    if(SummaryDisplayTypeDataField == null)
        return;
    DataSourceColumnBinding sourceBinding = new DataSourceColumnBinding(SourceDataFieldName);
    switch(ddlSummaryDisplayType.SelectedItem.Text) {
        case "AbsoluteVariation":
            SummaryDisplayTypeDataField.DataBinding = new DifferenceBinding(
                sourceBinding,
                CalculationPartitioningCriteria.RowValue,
                CalculationDirection.DownThenAcross,
                DifferenceTarget.Previous,
                DifferenceType.Absolute);
            SummaryDisplayTypeDataField.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
            SummaryDisplayTypeDataField.CellFormat.FormatString = "n0";
            break;
            // ...
    }
    SummaryDisplayTypeDataField.Caption = string.Format("{0}", ddlSummaryDisplayType.SelectedItem.Text);
}

Default.aspx.vb

Private Sub SetSelectedSummaryDisplayType()
    If SummaryDisplayTypeDataField Is Nothing Then Return
    Dim sourceBinding As DataSourceColumnBinding = New DataSourceColumnBinding(SourceDataFieldName)
    Select Case ddlSummaryDisplayType.SelectedItem.Text
        Case "AbsoluteVariation"
            SummaryDisplayTypeDataField.DataBinding = New DifferenceBinding(sourceBinding, CalculationPartitioningCriteria.RowValue, CalculationDirection.DownThenAcross, DifferenceTarget.Previous, DifferenceType.Absolute)
            SummaryDisplayTypeDataField.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric
            SummaryDisplayTypeDataField.CellFormat.FormatString = "n0"
            ' ...
    End Select

    SummaryDisplayTypeDataField.Caption = String.Format("{0}", ddlSummaryDisplayType.SelectedItem.Text)
End Sub

Note

Set PivotGridFieldBase.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: Pivot Grid for Web Forms - How to Change the Summary Display Mode

The following code snippet shows how to calculate the percent variances for the Pivot Grid cells:

Default.aspx.cs

void SetSelectedSummaryDisplayType() {
    if(SummaryDisplayTypeDataField == null)
        return;
    DataSourceColumnBinding sourceBinding = new DataSourceColumnBinding(SourceDataFieldName);
    switch(ddlSummaryDisplayType.SelectedItem.Text) {
    // ...
        case "PercentVariation":
            SummaryDisplayTypeDataField.DataBinding = new DifferenceBinding(
                sourceBinding,
                CalculationPartitioningCriteria.RowValue,
                CalculationDirection.DownThenAcross,
                DifferenceTarget.Previous,
                DifferenceType.Percentage);
            SummaryDisplayTypeDataField.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
            SummaryDisplayTypeDataField.CellFormat.FormatString = "p2";
            break;
            // ...
    }
    SummaryDisplayTypeDataField.Caption = string.Format("{0}", ddlSummaryDisplayType.SelectedItem.Text);
}

Default.aspx.vb

Private Sub SetSelectedSummaryDisplayType()
    If SummaryDisplayTypeDataField Is Nothing Then Return
    Dim sourceBinding As DataSourceColumnBinding = New DataSourceColumnBinding(SourceDataFieldName)
    Select Case ddlSummaryDisplayType.SelectedItem.Text
    ' ...
        Case "PercentVariation"
            SummaryDisplayTypeDataField.DataBinding = New DifferenceBinding(sourceBinding, CalculationPartitioningCriteria.RowValue, CalculationDirection.DownThenAcross, DifferenceTarget.Previous, DifferenceType.Percentage)
            SummaryDisplayTypeDataField.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric
            SummaryDisplayTypeDataField.CellFormat.FormatString = "p2"
            ' ...
    End Select

    SummaryDisplayTypeDataField.Caption = String.Format("{0}", ddlSummaryDisplayType.SelectedItem.Text)
End Sub

Note

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