The DevExpress ASP.NET MVC Spreadsheet supports the Pivot Tables functionality that allows end-users to calculate, categorize and analyze data in a worksheet. The pivot table displays a summary table that breaks the data into categories and calculates subtotals without typing any formulas.
End-users can specify the pivot table's layout parameters (data fields, columns, rows, summarize function) using the PivotTable Fields window. Various options on the PivotTable Tools ribbon tab also provides end-users ability to modify the pivot table (adjust the report layout, change formatting, specify field settings, etc.).
In this demo, the pivot table's report helps summarize sales data located in the Data worksheet. Items in the DATE field are consolidated into two groups - QUARTERS and MONTHS.
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).
The source code files for this demo are installed (by default) in the following directory:
Open CS Solution
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\MVCxSpreadsheetDemos