[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]ASP.NET WebForms Controls
 [Collapse]ASP.NET MVC Extensions
  [Expand]Product Information
  [Expand]Getting Started
  [Expand]Common Concepts
  [Expand]Grid View
  [Expand]Tree List
  [Expand]Card View
  [Expand]Reporting
  [Expand]Charting
  [Collapse]Pivot Grid
   [Expand]Getting Started
    Integrate the PivotGrid Extension into a Project
   [Expand]Binding to Data
    Main Features - PivotGrid
   [Expand]Export
    Client-Side Functionality
   [Collapse]UI Elements
     Cell
     Column Field
     Column Header Area
     Data Area
     Data Field
     Data Header Area
     Expand Button
     Field Value
     Filter Button
     Filter Button Panel
     Filter Field
     Filter Header Area
     Filter Window
     Grand Totals
     Pager
     Row Field
     Row Header Area
     Totals
   [Expand]Examples
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Scheduler
  [Expand]Site Navigation and Layout
  [Expand]HTML Editor
  [Expand]Vertical Grid
  [Expand]Data Editors Extensions
  [Expand]Docking and Popups
  [Expand]File Management
  [Expand]Data and Image Navigation
  [Expand]Multi-Use Site Extensions
  [Expand]SpellChecker
  [Expand]Query Builder
 [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]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Grand Totals

Row Grand Total is a row that displays summary totals calculated against all rows. Column Grand Total is a column that displays summary totals calculated against all columns.

 

The column (or row) grand total consists of the Header and Grand Total Value regions.

 

The table below lists the main properties that affect element appearance

Header:

Characteristics Members
Appearance PivotGridStyles.FieldValueGrandTotalStyle (via PivotGridSettings.Styles.FieldValueGrandTotalStyle)
Contents The default value ('Grand Total') can be changed by handling the PivotGridSettings.FieldValueDisplayText event.

Grand Total Values:

Characteristics Members
Appearance PivotGridStyles.GrandTotalCellStyle (via PivotGridSettings.Styles.GrandTotalCellStyle)
Contents PivotGridFieldBase.GrandTotalCellFormat (via MVCxPivotGridField.GrandTotalCellFormat)

The PivotGridSettings.CustomCellDisplayText event.

Expanded See Also

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