Welcome to DevExpress .NET Documentation
WinForms Controls
	Prerequisites
	What's Installed
	Build an Application
	Controls and Libraries
		Forms and User Controls
		Messages, Notifications and Dialogs
		Editors and Simple Controls
		Ribbon, Bars and Menu
		Application UI Manager
		Docking Library
		Data Grid
		Vertical Grid
		Pivot Grid
			Getting Started
			Fundamentals
			Binding to Data
			Data Shaping
			Data Analysis
			Layout
			Focus and Navigation
			Printing and Exporting
			Appearance
			Design-time Features
			Miscellaneous
			UI Elements
				Cell
				Column Field
				Column Header Area
				Data Area
				Data Field
				Data Field Summary Change Menu
				Data Header Area
				Empty Area
				Expand Button
				Field Header
				Field Header Context Menu
				Field Value
				Field Value Context Menu
				Filter Button and Drop-Down
				Filter Field
				Filter Header Area
				Filter Header Area Separator
				Grand Totals
				Header Area
				Header Area Context Menu
				Prefilter Panel
				Row Field
				Row Header Area
				Summary Filter Popup Window
				Totals
			End-User Capabilities
			Examples
			Member Tables
		Tree List
		Chart Control
		Diagrams
		Gauges
		Map Control
		Scheduler
		Spreadsheet
		Rich Text Editor
		Spell Checker
		Form Layout Managers
		Navigation Controls
		Printing-Exporting
		PDF Viewer
		Reporting
		Snap
		TreeMap Control
	Common Features
	Get More Help
	API Reference
ASP.NET Controls and MVC Extensions
ASP.NET Bootstrap Controls
ASP.NET Core Bootstrap Controls
WPF Controls
Xamarin Controls
Windows 10 App Controls
Document Server
Reporting
Report Server
Dashboard
eXpressApp Framework
CodeRush
CodeRush Classic
Cross-Platform Core Libraries
Tools and Utilities
End-User Documentation

WinForms Controls > Controls and Libraries > Pivot Grid > UI Elements > Totals

Totals

Row Totals are rows which display sub-totals calculated for outer row fields. Column Totals are columns which display sub-totals calculated for outer column fields.

PivotGridControl supports automatic and custom totals. Automatic totals are calculated using a summary function which is specified by a corresponding data field. Custom totals can be calculated using any summary function. It's possible to calculate multiple custom totals against a data field.

A column (or row) total consists of the Header and Total Values regions:

The table below lists the main properties which affect an element's appearance:

Visibility	PivotGridOptionsViewBase.ShowColumnTotals PivotGridOptionsViewBase.ShowRowTotals PivotGridOptionsViewBase.ShowTotalsForSingleValues PivotGridFieldOptions.ShowTotals PivotGridFieldBase.TotalsVisibility.
Custom Totals Availability	PivotGridFieldBase.TotalsVisibility
Custom Total Collection	PivotGridField.CustomTotals

Header:

Appearance	The PivotGridAppearancesBase.FieldValueTotal property. Note: the appearance settings are not in effect if the control is painted using the Windows XP, Office2003 or Skin painting scheme (see the PivotGridControl.LookAndFeel property).
Custom Draw Event	The PivotGridControl.CustomDrawFieldValue event.
Contents	The PivotGridFieldBase.TotalValueFormat and PivotGridCustomTotalBase.Format properties provide settings used to format the text within the total headers. The PivotGridControl.FieldValueDisplayText event enables the display text of individual values to be customized.

Total Values:

Appearance	The PivotGridAppearancesBase.TotalCell, PivotGridAppearancesBase.CustomTotalCell, PivotGridCustomTotal.Appearance and PivotGridFieldAppearances.CellTotal properties.
Custom Draw Event	The PivotGridControl.CustomDrawCell event.
Contents	The PivotGridFieldBase.TotalCellFormat and PivotGridCustomTotalBase.CellFormat properties provide settings used to format the values. The PivotGridControl.CustomCellDisplayText event enables the display text of individual values to be customized.

Totals

See Also