Share via

2.2.5.3.7.1 Page Axis

  • Article

The page axis contains the pivot fields (section 2.2.5.3.2) or pivot hierarchies (section 2.2.5.3.4) used to populate the page area (section 2.2.5.3.8.1.3) of the PivotTable (section 2.2.5) report, as specified by PivotTable Layout (section 2.2.5.3.8), and are intended for use as filters. These pivot fields and pivot hierarchies do not affect the layout of the other areas of the PivotTable report, but rather filter the data used by the entire PivotTable view (section 2.2.5.3).

The page axis is specified by the sequence of records that conforms to the SXPIS rule (defined in section 2.1.7.40). For non-OLAP PivotTables, each sequence of records that conforms to the SXPI rule (defined in section 2.1.7.40) specifies one pivot field on the page axis. For OLAP PivotTables, each SXPI rule specifies one pivot hierarchy (section 2.2.5.3.4) on the page axis. The order in which the pivot fields and pivot hierarchies appear in the SXPIS rule specifies the order that the pivot fields and pivot hierarchies appear in on the page axis.

For non-OLAP PivotTables, the isxvd field of the BrtBeginSXPI (section 2.4.255) record specifies the associated pivot field (section 2.2.5.3.2). For OLAP PivotTables, the isxth field of the BrtBeginSXPI record specifies the associated pivot hierarchy.