# 2.2.5.4.9.2 Row Axis

**Office**

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.