Show theme settings Shopping cart Download trialFree Trial
Change Theme Settings
Change Theme Settings
Show All Themes

Automatic Totals

Summary Options
Totals Options

The ASPxPivotGrid automatically calculates grand totals for each row and column. Additionally, totals are automatically calculated for each value group. The type of the automatic totals always matches the type of the summaries calculated in cells. Thus, automatic totals give you a more general data view while you still displaying the details. In this demo, you can use a number of view options to control the availability of totals.

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

The ASPxPivotGrid control supports automatic and custom totals. Automatic totals are calculated using a summary function 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.

See Also:
Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
Open CS Solution
Open VB Solution
The source code files for this demo are installed (by default) in the following directories:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\ASPxPivotGridDemos
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\VB\ASPxPivotGridDemos