Log In
[Expand]General Information
[Collapse]WinForms Controls
 [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]Binding to Data
   [Collapse]Data Shaping
       Automatic Totals
       Grand Totals
       Custom Totals
       Running Totals
      Aggregation Levels
     Data Formatting
   [Expand]Data Analysis
   [Expand]Focus and Navigation
   [Expand]Printing and Exporting
   [Expand]Design-time Features
   [Expand]UI Elements
   [Expand]End-User Capabilities
   [Expand]Member Tables
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Map Control
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]PDF Viewer
  [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]Report Server
[Expand]eXpressApp Framework
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Running Totals

Running totals allow you to calculate cumulative values that correspond to the specified column or row fields. For instance, the PivotGridControl in the image below displays cumulative sales for each quarter for two years.

To enable this capability for the required column or row field, use the PivotGridFieldBase.RunningTotal property. For instance, in the PivotGridControl below, running totals are enabled for the 'Order Quarter' field.

If the PivotGridFieldBase.RunningTotal property is set to true, cumulative values depend on the order of values. End-users can change the order by sorting, grouping or filtering.

Use the PivotGridOptionsData.AllowCrossGroupVariation property to specify whether running totals are calculated independently within individual groups, or for the entire Pivot Grid. In the image below, running totals for the 'Order Quarter' are calculated independently for each year (the PivotGridOptionsData.AllowCrossGroupVariation property is set to false).

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