Skip to main content
BuyLog In
ASP.NET Web Forms Controls
Search in…
Docs > ASP.NET WebForms Controls > Pivot Grid > Data Shaping > Aggregation > Summaries > Automatic Summaries
A newer version of this page is available. .
All docs
V19.1
ASP.NET Controls and MVC Extensions
Prerequisites
What's Installed
Common Concepts
ASP.NET WebForms Controls
Getting Started
Grid View
Tree List
Gantt
Card View
Reporting
Chart Control
Pivot Grid
Getting Started
Fundamentals
Binding to Data
Data Shaping
Aggregation
Summaries
Summary Overview
Automatic Summaries
Custom Summaries
Summary Display Modes
Accessing Summary Values
Obtaining Underlying Data (Drill-Down)
Totals
Aggregation Levels
Grouping
Sorting
Filtering
Data Analysis
Data Formatting
Layout
Appearance
Export
Design-Time Features
UI Elements
Examples
End-User Capabilities
Member Tables
Spreadsheet
Rich Text Editor
Scheduler
Site Navigation and Layout
HTML Editor
Gauges
Vertical Grid
Data Editors
Docking and Popups
File Management
Data and Image Navigation
Multi-Use Site Controls
Spell Checker
Query Builder
ASP.NET MVC Extensions
Localization
Redistribution and Deployment
Get More Help
.NET Framework API Reference
Client API Reference
Download CHM

Automatic Summaries

Automatic summaries are calculated against data fields. The type of the summary function is specified by the data field’s PivotGridFieldBase.SummaryType property.

The following summary functions are supported: Sum, Min, Max, Average, Count, Var (an estimate of the variance of a population), Varp (the variance of a population), StdDev (an estimate of the standard deviation of a population) and StdDevp (the standard deviation of a population). For a complete list of the predefined summary functions and their descriptions, see PivotSummaryType.

Note

For data fields that contain non-numeric values, only the Count, Min and Max functions can be used. Otherwise, the corresponding data cells display zeros.

See Also