Show theme settings Shopping cart Download trialFree Trial
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
  • 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.

Collapse/Expand
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).
Open CS Solution
The source code files for this demo are installed (by default) in the following directory:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\MVCxSpreadsheetDemos