The DevExpress ASP.NET Spreadsheet control (ASPxSpreadsheet) 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.