The DevExpress Pivot Grid (PivotGrid) extension is the ultimate tool for organizing and analyzing your business data. It is designed to summarize a large amount of information and display it in a cross-tabulated form and allows you to create financial and statistical reports. In addition, you can reorganize the layout using the PivotGrid’s drag-and-drop feature, which reorganizes business data according to the new column and row field layout.
The DevExpress ASP.NET MVC Pivot Grid extension supports a specific binding mode designed to efficiently work with large datasets. Within this binding mode, data-aware operations are performed on the database server side. This demo illustrates how the DevExpress ASP.NET MVC Pivot Grid can be bound to large databases using LINQ to SQL.