Show theme settings Shopping cart Download trialFree Trial
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
Qtr 1Qtr 2Qtr 3Qtr 4Grand Total
[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
 
2018
2019
[Expand]Steven Buchanan
[Expand]Chef Anton's Gumbo Mix
[Collapse]Genen Shouyu Total
 
[Collapse]Michael Suyama Total
 
2019
[Expand]Grandma's Boysenberry Spread
[Expand]Gula Malacca
[Expand]Louisiana Fiery Hot Pepper Sauce
[Expand]Louisiana Hot Spiced Okra
[Expand]Northwoods Cranberry Sauce
[Expand]Original Frankfurter grüne Soße
[Expand]Sirop d'érable
[Expand]Vegie-spread
[Expand]Confections
[Expand]Dairy Products
[Expand]Grains/Cereals
[Expand]Meat/Poultry
[Expand]Produce
[Expand]Seafood
[Expand]USA
Grand Total
428132353007336413887
9196334107042666
5443302013071382
49253020124
 50122486
   66
 50 1868
   1818
 50  50
  12 12
50100 4154
 12  12
 12  12
 12  12
50   50
64 5266182
21205265158
6024  84
70  1080
12064359228
60292020129
 6 8995
7753423893341840
8817067289103225
481164118157920
1073493183141088
192305221187905
3824066224511861
1266880777159952637430
1694911312101661289051317
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

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