[Expand]General Information
[Collapse]WinForms Controls
  .NET Core Support
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications, and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Expand]Property Grid
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Gantt Control
  [Expand]Chart Control
  [Expand]Map Control
   [Expand]Product Information
    Product Structure
    Getting Started
   [Expand]Spreadsheet Document
    Supported Formats
   [Expand]Cell Basics
    Defined Names
    Data Binding
    Data Validation
   [Expand]Data Presentation
    Data Grouping
   [Collapse]Pivot Tables
     Pivot Table Structure
     Pivot Table API
   [Expand]Charts and Graphics
   [Expand]Mail Merge
    Operation Restrictions
    Find and Replace
   [Expand]Visual Elements
   [Expand]Keyboard Shortcuts
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Sunburst Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Report and Dashboard Server
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Pivot Table Structure

This topic provides general information about the structure of a PivotTable report.

A pivot table refers to each column in the source range as a field. Each field is made up of items - unique data entries contained in this field.

In the initial stage, when you add a pivot table to a worksheet, it contains no data. To populate the created report with data, you should place the available data source fields into one of the four PivotTable sections.

  • Row Axis Area/Row Area

    Contains fields used to group report data by rows. A pivot table containing multiple row fields has one inner row field (the one located closest to the data area). All other row fields are regarded as outer row fields. Items of the outermost row field are displayed only once, while items in the rest of the row fields can be repeated.

  • Column Axis Area/Column Area

    Contains fields used to break report data into categories by columns. A pivot table containing multiple column fields has one inner column field. All other column fields are regarded as outer column fields. Items of the outermost column field are displayed only once, while items in the rest of the column fields can be repeated.

  • Data Area

    Contains fields against which summaries are calculated. As a rule, data fields contain numeric values, which are summarized with the Sum function, but you can change the calculation type by selecting one of the predefined functions (Count, Average, Min, Max, Product, Count Numbers, StdDev, StdDevp, Var, or Varp). For data fields containing textual values, the Count summary function is used by default.

  • Page/Report Filter Area

    Contains fields used to filter the entire PivotTable report to display data for the selected items.

For details on how to use the Pivot Table API to create a pivot table and organize its structure, refer to the How to: Create a Pivot Table example.

Expanded See Also

Is this topic helpful?​​​​​​​