Skip to main content
BuyLog In
WinForms Controls
Search in…
Docs > Controls and Libraries > Pivot Grid > UI Elements > Totals
All docs
V23.2
WinForms Controls
.NET/.NET Core Support
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
Property Grid
Pivot Grid
Getting Started
Fundamentals
Binding to Data
Asynchronous Mode
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 Popup
Filter Field
Filter Header Area
Filter Header Area Separator
Grand Totals
Header Area
Header Area Context Menu
Filter Panel
MRU (Most Recently Used) Filter List
Row Field
Row Header Area
Summary Filter Popup Window
Totals
End-User Capabilities
Examples
Tree List
Gantt Control
Chart Control
Diagrams
Gauges
Map Control
Scheduler
Spreadsheet
Rich Text Editor
Spell Checker
Form Layout Managers
Navigation Controls
Printing-Exporting
PDF Viewer
Reporting
Office File API
Snap
TreeMap Control
Sunburst Control
Sankey Diagram Control
Heatmap Control
Common Features
Security Considerations
UI Templates
Desktop & Web App UI Framework (Powered by EF Core)
Get More Help
API Reference
Download CHM

Totals

  • 2 minutes to read

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.

pivotgrid_totals

Custom totals can be calculated using any summary function. It’s possible to calculate multiple custom totals against a data field.

PivotGrid-CustomTotals

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

Visibility

PivotGridOptionsViewBase.ShowColumnTotals

PivotGridOptionsViewBase.ShowRowTotals

PivotGridOptionsViewBase.ShowTotalsForSingleValues

PivotGridOptionsViewBase.ShowCustomTotalsForSingleValues

PivotGridFieldOptions.ShowTotals

PivotGridFieldBase.TotalsVisibility

Custom Totals Availability

PivotGridFieldBase.TotalsVisibility

Custom Total Collection

PivotGridField.CustomTotals

Total Location

PivotGridOptionsViewBase.RowTotalsLocation

PivotGridOptionsViewBase.ColumnTotalsLocation

 

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.

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.

See Also