Show theme settings Shopping cart Download trialFree Trial
Spell Checker
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, MVC Pivot Grid shows all rows in a hierarchical way, which is common for pivot tables (Full Layout). However, when there are a lot of fields in the Row Area, this kind of presentation may produce a cumbersome layout. To avoid this, the PivotGrid extension allows you to arrange row headers in a tree-like manner (Compact Layout), as shown in this demo.

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
The source code files for this demo are installed (by default) in the following directory:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\MVCxPivotGridDemos