Free Trial Buy Now

Appearance & Layout - Compact Layout

 
Complex Pivot Table
[Layout Button]
[Hidden Field's Headers]
Hidden Fields
[Filter Area Headers]
Filter Area
UnitPrice
[Filter]
[Row Area Headers]
Row Area
Country
(Ascending)[Filter]
Category Name
(Ascending)[Filter]
Product Name
(Ascending)[Filter]
Customer
(Ascending)[Filter]
Order Year
(Ascending)[Filter]
Order Quarter
(Ascending)[Filter]
[Column Area Headers]
Column Area
[Data Area Headers]
Data Area
Quantity
Update
 
Page 1 of 2 (31 items)
Prev
1
2
Next
[Collapse]UK Total
 
[Expand]Beverages
[Collapse]Condiments Total
 
[Expand]Aniseed Syrup
[Collapse]Chef Anton's Cajun Seasoning Total
 
[Expand]Michael Suyama
[Collapse]Robert King Total
 
[Collapse]1994 Total
 
Qtr 4
[Expand]1995
[Expand]Steven Buchanan
[Expand]Chef Anton's Gumbo Mix
[Collapse]Genen Shouyu Total
 
[Collapse]Michael Suyama Total
 
[Expand]1995
Grand Total
Page 1 of 2 (31 items)
Prev
1
2
Next

Description

By default, the ASPxPivotGridControl shows all rows in a hierarchical way, which is common for pivot tables (Full Layout). However, when there are a lot of data fields in a Row Area, it may be necessary to show them in a tree-like manner (Compact Layout). In this demo, you can switch from Compact Layout to Full Layout and move data fields from one area to another to see what the pivot grid looks like with these settings.

Version: v2012 vol 2.8
Experience the DevExpress Difference Today
Demos with source code are included with an installation of DevExpress controls for ASP.NET. Refer to the Demos and Sample Applications topic to learn more.
To download your free evaluation copy of our award-winning ASP.NET libraries, visit the Downloads page
All DevExpress ASP.NET Controls ship as part of DXperience ASP.NET, Enterprise, and Universal.
To obtain pricing information, visit the Pricing Options page or contact us via Email at info@devexpress.com
or by telephone at +1 (818) 844-3383 between 8:30am and 5pm Pacific Time.