Log In
[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
  [Expand]Chart Control
  [Expand]Grid View
  [Expand]Card View
  [Expand]Vertical Grid
  [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]HTML Editor
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Expand]Binding to Data
   [Collapse]Data Shaping
       Running Totals
       Automatic totals
       Custom Totals
       Grand Totals
      Aggregation Levels
   [Expand]Data Analysis
   [Expand]Data Formatting
   [Expand]Data Export
   [Expand]Design-Time Features
   [Expand]UI Elements
   [Expand]End-User Capabilities
   [Expand]Member Tables
  [Expand]Tree List
  [Expand]Data Editors
  [Expand]Spell Checker
  [Expand]Query Builder
 [Expand]ASP.NET MVC Extensions
 [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]Report Server
[Expand]eXpressApp Framework
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Grand Totals

There are two types of grand totals: row and column. Row Grand Total(s) are row(s) which display summary totals calculated against all rows in a pivot grid. Column Grand Total(s) are column(s) which display summary totals calculated against all columns in a pivot grid. The summary function used to calculate an automatic grand total is determined by the corresponding data field's PivotGridFieldBase.SummaryType property.

If there are multiple data fields, the Pivot Grid control displays multiple column grand totals (for each data field), and a single row grand total (see the image below).

To specify the visibility of column and row grand totals, use the PivotGridOptionsViewBase.ShowColumnGrandTotals and PivotGridOptionsViewBase.ShowRowGrandTotals properties, respectively. To hide grand totals that correspond to a particular data field, set the field's PivotGridFieldOptions.ShowGrandTotal property to false.

By default, if a single value of an outer column field is listed along the pivot grid's top edge, the column grand total(s) is not displayed. Similarly, the row grand total(s) is not displayed if a single value of an outer row field is listed along the control's left edge. To display grand totals for single field values, set the PivotGridOptionsViewBase.ShowGrandTotalsForSingleValues property to true.

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

Expanded See Also

Is this topic helpful?​​​​​​​