2.2.5.4.9.3 Column Axis

  • Article

The column 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 column area (section 2.2.5.4.10.1.2) 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 second 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 SxIvdCol structures (section 2.5.257).

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 column 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 column 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 column area (section 2.2.5.4.10.1.2) of the PivotTable report (section 2.2.5).

For adjacent SxIvdCol structures (section 2.5.257) 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 SxIvdCol references (section 2.5.257)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 SxIvdCol references (section 2.5.257). The pivot field (section 2.2.5.4.3) or data field (section 2.2.5.4.9.5.2) that the second SxIvdCol references (section 2.5.257) 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 SxIvdCol references (section 2.5.257).

For OLAP PivotTables (section 2.2.5), all SxIvdCol structures (section 2.5.257) 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 column 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 column 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.