Change Theme Settings
Change Theme Settings
Themes
 
Show All Themes
v
...v

PivotTables

  • Undo

    Undo
    po
  • Clipboard

    Clipboard
    po
  • v
    v
    popopopo
    Font

    Font
    po
  • Alignment

    Alignment
    po
  • po
    dialogboxlauncherNumber

    Number
    po
  • Cells

    Cells
    po
  • Editing

    Editing
    po
  • Styles

    Styles
    po
  • dialogboxlauncherPage Setup

    Page Setuppo
  • dialogboxlauncherPrint

    Print
    po
  • Document Views

    Document Viewspo
  • Show

    Show
    po
  • View

    View
    po
  • Window

    Window
    po
  • Table Name
    Properties

    Properties
    po
  • Tools

    Tools
    po
  • Table Style Options

    Table Style Optionspo
  • Table Style Options

    Table Style Optionspo
  • Layout

    Layout
    po
  • PivotTable Style Options

    PivotTable Style Optionspo
 


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.