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.