Share via

2.2.5.4.9.2 Row Axis

  • Article

The row axis contains the pivot fields (section 2.2.5.4.3) and an optional data field (section 2.2.5.4.9.5.2) used to populate the row area (section 2.2.5.4.10.1.1) of the PivotTable report (section 2.2.5), as specified by the PivotTable Layout section.

The pivot fields (section 2.2.5.4.3) on the row axis are specified by the first SxIvd record (section 2.4.292) in the sequence of records that conform to the PIVOTCORE rule (section 2.1.7.20.5) as defined by the Worksheet Substream ABNF, which specifies an array of SxIvdRw structures (section 2.5.258). The order that the pivot fields (section 2.2.5.4.3) and the optional data field (section 2.2.5.4.9.5.2) are referenced from the SxIvd record (section 2.4.292) specifies the order that the pivot fields (section 2.2.5.4.3) and the optional data field (section 2.2.5.4.9.5.2) display on the row axis. The order that the pivot fields (section 2.2.5.4.3) and the optional data field (section 2.2.5.4.9.5.2) display on the row axis corresponds to the order that the pivot fields (section 2.2.5.4.3) and the optional data field (section 2.2.5.4.9.5.2) are placed in the row area (section 2.2.5.4.10.1.1) of the PivotTable report (section 2.2.5).

For adjacent SxIvdRw structures (section 2.5.258) in the rgSxivd field of the SxIvd record (section 2.4.292), the pivot field (section 2.2.5.4.3) or data field (section 2.2.5.4.9.5.2) that the first SxIvdRw references (section 2.5.258) is defined to be an outer field with respect to the pivot field (section 2.2.5.4.3) or the data field (section 2.2.5.4.9.5.2) that the second SxIvdRw references (section 2.5.258). The pivot field (section 2.2.5.4.3) or data field (section 2.2.5.4.9.5.2) that the second SxIvdRw references (section 2.5.258) is defined to be an inner field with respect to the pivot field (section 2.2.5.4.3) or the data field (section 2.2.5.4.9.5.2) that the first SxIvdRw references (section 2.5.258).

For OLAP PivotTables (section 2.2.5), all SxIvdRw records (section 2.5.258) in the rgSxivd field of the SxIvd record (section 2.4.292) that reference pivot fields (section 2.2.5.4.3) that are associated with the same pivot hierarchy (section 2.2.5.4.5) MUST be adjacent. Pivot fields (section 2.2.5.4.3) associated with member properties (section 2.2.5.4.6) of the pivot hierarchy (section 2.2.5.4.5) MUST be located on the row axis after other types of pivot fields (section 2.2.5.4.3) associated with the same pivot hierarchy (section 2.2.5.4.5). Pivot fields (section 2.2.5.4.3) not associated with member properties (section 2.2.5.4.6) of the pivot hierarchy (section 2.2.5.4.5) MUST appear on the row axis in an order such that the zero-based ordinal of the OLAP level of each pivot field (section 2.2.5.4.3) associated with the same pivot hierarchy (section 2.2.5.4.5) is ascending. The zero-based ordinal of the OLAP level of a pivot field (section 2.2.5.4.3) is specified by the isxtl field of the SXVDTEx record (section 2.4.311).

For OLAP PivotTables (section 2.2.5), the SXTH record (section 2.4.308) specifies information about a pivot hierarchy (section 2.2.5.4.5), including which axis the pivot hierarchy (section 2.2.5.4.5) is on.

See the Nesting section for more information.