Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
  [Expand]Reporting
  [Expand]Chart Control
  [Expand]Grid View
  [Expand]Card View
  [Expand]Vertical Grid
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Image and Data Browsing
  [Expand]Docking and Popups
  [Expand]Site Navigation and Layout
  [Expand]File Management
  [Expand]Multi-Use Site Controls
  [Expand]Scheduler
  [Expand]HTML Editor
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Expand]Fundamentals
   [Expand]Binding to Data
   [Collapse]Data Shaping
    [Collapse]Aggregation
     [Expand]Summaries
     [Collapse]Totals
       Running Totals
       Automatic totals
       Custom Totals
       Grand Totals
      Aggregation Levels
     Grouping
    [Expand]Sorting
    [Expand]Filtering
   [Expand]Data Analysis
   [Expand]Data Formatting
   [Expand]Layout
   [Expand]Appearance
   [Expand]Data Export
   [Expand]Design-Time Features
   [Expand]UI Elements
   [Expand]Examples
   [Expand]End-User Capabilities
   [Expand]Member Tables
  [Expand]Tree List
  [Expand]Gauges
  [Expand]Data Editors
  [Expand]Spell Checker
  [Expand]Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Localization
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core 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]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Automatic totals

Automatic totals are calculated using a summary function which is specified by the corresponding data field. These totals are automatically calculated for groups of data, and displayed for field values which have nested field values.

An automatic total is calculated for each data field. By default, if there are multiple data fields, the ASPxPivotGrid control displays multiple column totals and a single row total for each field value. In the image below, the ASPxPivotGrid control contains two data fields, and it displays two column totals and a single row total for appropriate field values.

To reverse the layout, and display multiple row totals and a single column total, set the PivotGridOptionsDataField.Area property to PivotDataArea.RowArea.

The summary function used to calculate automatic totals is the same as the summary function used in data cells. It is specified by the data field's PivotGridFieldBase.SummaryType property.

If a specific field value has a single nesting field value, a corresponding subtotal is not displayed, by default. To display totals for such field values, set the PivotGridOptionsViewBase.ShowTotalsForSingleValues property to true.

To hide column and row subtotals, use the PivotGridOptionsViewBase.ShowColumnTotals and PivotGridOptionsViewBase.ShowRowTotals properties. It's also possible to hide totals that correspond to a particular data field by setting its PivotGridFieldOptions.ShowTotals property to false.

Expanded See Also

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