Share via

2.2.5.4.9 PivotTable Axes

  • Article

A PivotTable axis is the set of pivot fields (section 2.2.5.4.3) or pivot hierarchies (section 2.2.5.4.5) in a PivotTable view (section 2.2.5.4) used to populate an area of the PivotTable report (section 2.2.5). The placement and positions of pivot fields (section 2.2.5.4.3) on the axes are used to determine the PivotTable Layout (section 2.2.5.4.10). The four axes of a PivotTable view (section 2.2.5.4) are the page axis (section 2.2.5.4.9.1), the row axis (section 2.2.5.4.9.2), the column axis (section 2.2.5.4.9.3), and the data axis (section 2.2.5.4.9.5). For non- OLAP PivotTable views (section 2.2.5.4.2), a pivot field (section 2.2.5.4.3) MUST NOT appear more than once on the PivotTable view (section 2.2.5.4), with the exception of the data axis (section 2.2.5.4.9.5). For non-OLAP PivotTable views (section 2.2.5.4.2), a pivot field (section 2.2.5.4.3) can be placed one or more times on the data axis (section 2.2.5.4.9.5) independently of whether it was placed on any other axis. For OLAP PivotTable views (section 2.2.5.4.2), a pivot field (section 2.2.5.4.3) MUST NOT be placed more than once on any axis. For both OLAP and non-OLAP PivotTable views (section 2.2.5.4.2), pivot fields (section 2.2.5.4.3) do not have to be placed on any PivotTable axis.