[Expand]General Information
[Collapse]WinForms Controls
  .NET Core Support
  Prerequisites
 [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
  [Expand]Property Grid
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Expand]Fundamentals
   [Expand]Binding to Data
   [Expand]Data Shaping
   [Expand]Data Analysis
   [Expand]Layout
   [Expand]Focus and Navigation
   [Expand]Printing and Exporting
   [Expand]Appearance
   [Expand]Design-Time Features
   [Expand]Miscellaneous
   [Expand]UI Elements
   [Expand]End-User Capabilities
   [Collapse]Examples
    [Expand]Providing Data
    [Collapse]Summarization
      How to: Implement Custom Summary
      How To: Display Custom Summary in Totals
      How to: Add Custom Totals
      How to: Calculate Multiple Custom Totals with Custom Summary Type
      How to: Locate a Column (Row) Header By Its Summary Values
    [Expand]Sorting
    [Expand]Grouping
    [Expand]Filtering
    [Expand]Drill-Down (Underlying Data)
    [Expand]Editing
    [Expand]Layout Features
    [Expand]Formatting
    [Expand]Data Output
    [Expand]Appearance
    [Expand]Serialization
   [Expand]Member Tables
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Diagrams
  [Expand]Gauges
  [Expand]Map Control
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]Printing-Exporting
  [Expand]PDF Viewer
   Reporting
  [Expand]Snap
  [Expand]TreeMap Control
  [Expand]Sunburst Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[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]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

How To: Display Custom Summary in Totals

The following example demonstrates how to calculate and display the difference of Income and Outlay in totals.

In this example, a custom Grand Total is implemented for the Value data field.

To show additional Grand Total rows or columns, add a field to the Data Area. Then, set the field's PivotGridFieldBase.SummaryType property to Custom. To provide values for this field, use the PivotGridControl.CustomSummary event. You can use the PivotGridCustomSummaryEventArgsBase<T>.CreateDrillDownDataSource method to get a list of all corresponding underlying data source rows, and then you will be able to calculate summary values.

The image below shows the result.

To learn more about custom summaries, see the Custom Summaries topic.

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