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

Multiple Totals

Page 1 of 6 (117 items)Prev123456Next
Category Name(Ascending)[Filter]
Product Name(Ascending)[Filter]
Grand Total
QuantityExtended Price
[Collapse]BeveragesChai
Chang
Chartreuse verte
Côte de Blaye
Guaraná Fantástica
Ipoh Coffee
Lakkalikööri
Laughing Lumberjack Lager
Outback Lager
Rhönbräu Klosterbier
Sasquatch Ale
Steeleye Stout
Beverages Average
Beverages Sum
Beverages Max
Beverages Min
Beverages Count
[Collapse]CondimentsAniseed Syrup
Chef Anton's Cajun Seasoning
Chef Anton's Gumbo Mix
Grand Total
828$1,152.00
1057$1,425.00
793$2,106.00
623$15,810.00
1125$495.00
580$2,760.00
981$1,440.00
184$476.00
817$750.00
1155$883.50
506$1,197.00
883$1,440.00
23.59$663.04
9532$267,868.19
130$15,810.00
2$13.50
404404
328$600.00
453$1,045.00
298$1,494.50
51317$15,810.00
Page 1 of 6 (117 items)Prev123456Next
Select Totals to Show
Did this demo address your needs?
If you’d like us to extend this demo further, please describe your needs below.
Thank you in advance for your cooperation.
SEND FEEDBACK

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
Multi-Use Site Controls