Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]Welcome to DevExpress .NET Documentation
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Collapse]WPF Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Collapse]Controls and Libraries
  [Expand]Windows and Utility Controls
   Dialogs, Notifications and Panels
   Reporting
  [Expand]Data Grid
  [Expand]Ribbon, Bars and Menu
  [Expand]Charts Suite
  [Expand]Pivot Grid
  [Expand]Scheduler
  [Collapse]Spreadsheet
    Product Structure
   [Expand]Getting Started
   [Expand]Spreadsheet Document
    Supported Formats
   [Expand]Cell Basics
   [Expand]Formulas
    Defined Names
    Data Binding
    Data Validation
   [Expand]Data Presentation
   [Collapse]Pivot Table Overview
     Pivot Table Structure
     Pivot Table API
   [Expand]Charting Overview
    Printing
    Protection
    Find and Replace
   [Expand]Visual Elements
    Services
    Themes and Templates
   [Expand]Examples
  [Expand]Rich Text Editor
  [Expand]Tree List
  [Expand]Gauge Controls
  [Expand]Map Control
  [Expand]Layout Management
  [Expand]Windows Modern UI
  [Expand]Printing-Exporting
  [Expand]Data Editors
  [Expand]Navigation Controls
  [Expand]Spell Checker
  [Expand]Property Grid
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Diagram Control
  [Expand]Scheduler (legacy)
 [Expand]Scaffolding Wizard
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

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?​​​​​​​