About the Pivot Grid
The DevExpress Pivot Grid is the ultimate tool for organizing and analyzing your business data. Its main functionality is ability to summarize large amounts of information and represent it in a cross-tabulated form. This functionality allows creating financial and statistical reports.
PivotGrid allows you to easily reorganize the extension's layout using drag-and-drop. As a result, business data will be re-summarized according to a new layout of column and row fields.
The following code demonstrates how to add a pivot grid to your project, bind it to a data source, and create pivot grid fields that are mapped to appropriate fields from a database.
Partial View code:
The controller is where you will need to define the action methods that handle PivotGrid's callbacks. The "OverviewPartial" action method below handles the callbacks. While the GetSalesPerson action method gets the data from the model to pass to the View. As you can see, the native DevExpress PivotGrid extension follows the ASP.NET MVC pattern while providing powerful features for your end-users.