Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]Welcome to DevExpress .NET Documentation
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Collapse]WPF Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Collapse]Controls and Libraries
  [Expand]Windows and Utility Controls
   Dialogs, Notifications and Panels
   Reporting
  [Expand]Data Grid
  [Expand]Ribbon, Bars and Menu
  [Expand]Charts Suite
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Expand]Fundamentals
   [Expand]Binding to Data
   [Collapse]Data Shaping
    [Collapse]Aggregation
     [Expand]Summaries
     [Collapse]Totals
       Totals Overview
       Grand Totals
       Custom Totals
       Running Totals
      Aggregation Levels
     Grouping
    [Expand]Sorting
    [Expand]Filtering
    [Expand]Data Formatting
   [Expand]Data Analysis
   [Expand]Layout
   [Expand]Printing and Exporting
   [Expand]Appearance
   [Expand]MVVM Enhancements
   [Expand]Miscellaneous
   [Expand]UI Elements
   [Expand]End-User Capabilities
   [Expand]Examples
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Tree List
  [Expand]Gauge Controls
  [Expand]Map Control
  [Expand]Layout Management
  [Expand]Windows Modern UI
  [Expand]Printing-Exporting
  [Expand]Data Editors
  [Expand]Navigation Controls
  [Expand]Spell Checker
  [Expand]Property Grid
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Diagram Control
  [Expand]Scheduler (legacy)
 [Expand]Scaffolding Wizard
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[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

Grand Totals

The Pivot Grid can display 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 PivotGridField.SummaryType property.

If there are multiple data fields, the DXPivotGrid displays multiple column grand totals (for each data field), and a single row grand total.

To change the default text displayed within the grand total's header, use the field's PivotGridField.GrandTotalText property. Use the PivotGridField.GrandTotalCellFormat property to specify the formatting settings applied to grand total values.

Expanded Visibility

The visibility of all column and row grand totals is specified by the PivotGridControl.ShowColumnGrandTotals and PivotGridControl.ShowRowGrandTotals properties, respectively. To hide grand totals which correspond to an individual data field, set the data field's PivotGridField.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 PivotGridControl.ShowGrandTotalsForSingleValues property to true.

Expanded Location

The location of row totals and grand totals is specified by the PivotGridControl.RowTotalsLocation property. The PivotGridControl.ColumnTotalsLocation property specifies the location of column totals and grand totals.

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