Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Expand]Fundamentals
   [Expand]Binding to Data
   [Collapse]Data Shaping
    [Collapse]Summarization
     [Collapse]Summaries
       Summaries Overview
       Automatic Summaries
       Custom Summaries
      [Collapse]Summary Display Modes
        Variation Modes
        Percentage Modes
        Rank Modes
        Index Mode
       Accessing Cell Values
       Obtaining Underlying Data (Drill-Down)
     [Expand]Totals
      Aggregation Levels
     Grouping
    [Expand]Sorting
    [Expand]Filtering
    [Expand]Editing
     Data Formatting
   [Expand]Data Analysis
   [Expand]Layout
   [Expand]Focus and Navigation
   [Expand]Printing and Exporting
   [Expand]Appearance
   [Expand]Design-time Features
   [Expand]Miscellaneous
   [Expand]UI Elements
   [Expand]End-User Capabilities
   [Expand]Examples
   [Expand]Member Tables
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Diagrams
  [Expand]Gauges
  [Expand]Map Control
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]Printing-Exporting
  [Expand]PDF Viewer
   Reporting
  [Expand]Snap
  [Expand]TreeMap Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Variation Modes

Variation summary display modes are used to display absolute and percent variances between the current value and the previously calculated value for the current field.

The following variation modes are available.

  • PivotSummaryDisplayType.AbsoluteVariation

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

    In the following image, two data fields are bound to the same field ("Order Count"). Their SummaryType properties are set to Sum, but the SummaryDisplayType properties are set to Default and AbsoluteVariation respectively.

    For instance, the "Andrew Fuller - Quarter 4 - AbsoluteVariation" cell value is calculated as follows: 17 = 24 - 7, where 24 - is the actual sum calculated against the Order Count field for "Andrew Fuller - Quarter 4", and 7 is the previous summary value ("Andrew Fuller - Quarter 3").

  • PivotSummaryDisplayType.PercentVariation

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

    In the following image, the SummaryDisplayType properties of the two data fields are set to Default and PercentVariation respectively.

    For instance, the "Andrew Fuller - Quarter 4 - PercentVariation" cell value is calculated as follows: 2.4286 = (24-7)/7. In this mode, values are automatically formatted as percentages, so the cell displays "242.86%" instead of "2.4286". To specify formatting settings, use the data field's PivotGridFieldBase.CellFormat property.

Expanded See Also

How would you rate this topic?​​​​​​​