Skip to main content
BuyLog In
Silverlight Controls
Search in…
Docs > Silverlight Controls > Controls > Pivot Grid > Concepts > Data-Related Features > Aggregation > Totals > Totals Overview
All docs
V14.2
Silverlight Controls
What Is New
Installation and Demos
Common Concepts
Controls
Reporting
Data Grid
Ribbon Controls
Toolbar-Menu
Chart Control
Pivot Grid
Product Information
Getting Started
Fundamentals
Concepts
Providing Data
Data-Related Features
Aggregation
Summaries
Totals
Totals Overview
Grand Totals
Custom Totals
Aggregation Levels
Grouping
Sorting
Filtering
Asynchronous Mode
Layout Features
Data Formatting
Data Output
End-User Interaction
Styles and Templates
Miscellaneous
Visual Elements
End-User Capabilities
Examples
Scheduler
Rich Text Editor
Tree List
Gauge Controls
Map Control
Dock Windows
Tile and Layout
Printing-Exporting
Data Editors
Navigation Bar
Utility Controls
Spell Checker
LightSwitch Reporting
Localization
Redistribution and Deployment
Get More Help
API Reference

Totals Overview

  • 2 minutes to read

PivotGridControl supports three types of totals: automatic totals (subtotals), custom totals and grand total. Totals are displayed as additional columns (column totals) or rows (row totals) and contain summarized data.

pivotgrid_totals

#Automatic Totals (Subtotals)

Automatic totals are calculated using a summary function specified by the corresponding data field (PivotGridField.SummaryType). These totals are automatically calculated for groups of data, and displayed for field values which have nested field values.

An automatic total is calculated for each data field. By default, if there are multiple data fields, the DXPivotGrid control displays multiple column totals and a single row total for each field value. In the image below, the DXPivotGrid control has two data fields. It displays two column totals and a single row total for appropriate field values.

To display multiple row totals and a single column total, set the PivotGridControl.DataFieldArea property to FieldArea.RowArea.

By default, a subtotal is not displayed if a field value has a single nesting field value. To display totals for such field values, set the PivotGridControl.ShowTotalsForSingleValues property to true.

To specify the visibility of all column and row subtotals, use the PivotGridControl.ShowColumnTotals and PivotGridControl.ShowRowTotals properties. To hide totals which correspond to an individual data field, set its PivotGridField.ShowTotals property to false.