# 2.2.5.4.9.3 Column Axis

**Office**

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.