Back to Devexpress

Pivot Table Structure

officefileapi-118493-spreadsheet-document-api-pivot-tables-pivot-table-structure.md

latest1.1 KB
Original Source

Pivot Table Structure

  • Sep 19, 2023
  • 2 minutes to read

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

  • Column Axis Area/Column Area

  • Data Area

  • Page/Report Filter Area

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.