Share via

2.2.5.4.9.1 Page Axis

  • Article

The page axis contains the pivot fields (section 2.2.5.4.3) or pivot hierarchies (section 2.2.5.4.5) that populate the page area (section 2.2.5.4.10.1.3) of the PivotTable report (section 2.2.5), as specified by PivotTable Layout (section 2.2.5.4.10), and that are intended for use as filters. These pivot fields (section 2.2.5.4.3) and pivot hierarchies (section 2.2.5.4.5) do not affect the layout of the other areas of the PivotTable report (section 2.2.5), but rather filter the data used by the entire PivotTable view (section 2.2.5.4.2).

The page axis is specified by the sequence of records that conform to the PIVOTPI rule (section 2.1.7.20.5) and optionally by the collection of SXPIEx records (section 2.4.299) in the sequence of records that conform to the PIVOTVIEWEX rule (section 2.1.7.20.5). For non-OLAP PivotTable views (section 2.2.5.4.2), the SXPI_Item structure (section 2.5.260) specified by each array element of the rgsxpi field of the SXPI record (section 2.4.298) specifies one pivot field (section 2.2.5.4.3) on the page axis. For OLAP PivotTable views (section 2.2.5.4.2), each SXPIEx record (section 2.4.299) specifies one pivot hierarchy (section 2.2.5.4.5) on the page axis. The order of the pivot fields (section 2.2.5.4.3) and pivot hierarchies (section 2.2.5.4.5) in these collections for the non-OLAP and OLAP cases specifies the order in which the pivot fields (section 2.2.5.4.3) and pivot hierarchies (section 2.2.5.4.5) appear on the page axis.

For non-OLAP PivotTable views (section 2.2.5.4.2), the isxvd field of the SXPI_Item structure (section 2.5.260) specifies the associated pivot field (section 2.2.5.4.3). For OLAP PivotTable views (section 2.2.5.4.2), the isxth field of the SXPIEx record (section 2.4.299) specifies the associated pivot hierarchy (section 2.2.5.4.5).