[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Collapse]WPF Controls
 [Expand]What's Installed
 [Expand].NET Core 3 Support
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Collapse]Controls and Libraries
  [Expand]Data Grid
  [Expand]Ribbon, Bars and Menu
  [Expand]Charts Suite
  [Expand]Pivot Grid
    Product Structure
   [Expand]Getting Started
   [Expand]Spreadsheet Document
    Supported Formats
   [Expand]Cell Basics
    Defined Names
    Data Binding
    Data Validation
   [Expand]Data Presentation
   [Collapse]Pivot Table Overview
     Pivot Table Structure
     Pivot Table API
   [Expand]Charts and Graphics
    Operation Restrictions
    Find and Replace
   [Expand]Mail Merge
   [Expand]Visual Elements
    Themes and Templates
  [Expand]Rich Text Editor
  [Expand]Tree List
  [Expand]Gauge Controls
  [Expand]Map Control
  [Expand]Layout Management
  [Expand]Windows Modern UI
  [Expand]Data Editors
  [Expand]Navigation Controls
  [Expand]Spell Checker
  [Expand]Property Grid
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Gantt Control
  [Expand]Diagram Control
  [Expand]Windows and Utility Controls
   Dialogs, Notifications and Panels
  [Expand]Scheduler (legacy)
 [Expand]Scaffolding Wizard
  Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[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?​​​​​​​