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

OLAP Multiple Totals

ErrorTo run this demo, you should have data providers used for Analysis Services connections installed on your system.
See OLAP Requirements and Limitations for details.
City
Country
Select Totals to Show

For each field, you can manually specify the number and type of group totals to be displayed. This demo shows how to display the Average, Sum, Maximum and Minimum summaries for each Category group.

The CustomTotals collection contains PivotGridCustomTotal objects that represent custom totals for the field. These custom totals are displayed when the field is located within the Column Header Area or Row Header Area and only if its TotalsVisibility property is set to PivotTotalsVisibility.CustomTotals.


See Also:
Collapse/Expand
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