Pivot Grid - OLAP OLAP Multiple Totals

Select Totals to Show:
Page 1 of 2 (17 items)Prev12Next
Country[Filter]
City[Filter]
Quantity
Discount
Drop Column Fields Here
Category Name(Ascending)[Filter]
Products(Ascending)[Filtered]
[Collapse]BeveragesChang
Guaraná Fantástica
Outback Lager
Sasquatch Ale
Beverages Average
Beverages Count
Beverages Max
Beverages Min
Beverages Sum
[Expand]Condiments
Grand Total
Page 1 of 2 (17 items)Prev12Next

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:
Version: v2013 vol 2.9
Copyright © 2006-2014 Developer Express Inc
Your Next Great ASP.NET App Starts Here

Get started today and download your 30-day trial of ASP.NET Controls and Libraries (includes 30 days of free technical support).

All demos ship with full source code and are included in the DevExpress ASP.NET distribution. Refer to the Demos and Sample Applications topic to learn more.

DevExpress ASP.NET Controls and Libraries ship as part of DevExpress Universal, DXperience and ASP.NET Subscriptions and are backed by a 60 day unconditional money-back guarantee.
To learn more and obtain pricing information, visit the Compare Features and Pricing webpage. For immediate assistance, contact us by Email at info@devexpress.com or by phone at +1 (818) 844-3383 between 7:30am and 4:30pm Pacific Time.