Change Theme Settings
Change Theme Settings
Themes
 
Show All Themes
v
...v

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]
[Column Area Headers]
Column Area
Order Quarter
(Ascending)[Filter]
[Data Area Headers]
Data Area
Quantity
Update

By default, the ASPxPivotGrid 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.


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