Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

2.2.5.4.10.1.1 Row Area

Office

The row area contains pivot fields (section 2.2.5.4.3), the optional data field (section 2.2.5.4.9.5.2), or both that are placed on the row axis (section 2.2.5.4.9.2), along with associated pivot items (section 2.2.5.4.4) and data items (section 2.2.5.4.9.5.1). The first row of the row area can contain pivot field (section 2.2.5.4.3) captions, data field (section 2.2.5.4.9.5.2) captions, or both as specified by the fNoHeaders field of the SXAddl_SXCView_SXDVer12Info record (section 2.4.273.109). If the fNoHeaders field of the SXAddl_SXCView_SXDVer12Info record (section 2.4.273.109) is equal to 0 or the SXAddl_SXCView_SXDVer12Info record (section 2.4.273.109) is not present, the pivot field (section 2.2.5.4.3) and data field (section 2.2.5.4.9.5.2) captions are located above their pivot items (section 2.2.5.4.4) or data items (section 2.2.5.4.9.5.1).

Pivot items (section 2.2.5.4.4) or data items (section 2.2.5.4.9.5.1) of the pivot field (section 2.2.5.4.3) or data field (section 2.2.5.4.9.5.2) that has a position of 0 on the row axis (section 2.2.5.4.9.2) are placed in the first column of the row area. For every other pivot field (section 2.2.5.4.3) or data field (section 2.2.5.4.9.5.2) on the row axis (section 2.2.5.4.9.2), placement of pivot items (section 2.2.5.4.4) or data items (section 2.2.5.4.9.5.1) are calculated as follows:

For the data field (section 2.2.5.4.9.5.2), if the fCompactData field and the fOutlineData field of the SXAddl_SXCView_SXDVer12Info record (section 2.4.273.109) are equal to 1, this specifies that the data field (section 2.2.5.4.9.5.2) is in compact axis mode. If the SXAddl_SXCView_SXDVer12Info (section 2.4.273.109) is not present, the data field (section 2.2.5.4.9.5.2) is not in compact axis mode.

For pivot fields (section 2.2.5.4.3), if the fCompact flag on the SXAddl_SXCField12_SXDVer12Info record (section 2.4.273.33) is equal to 1 and fOutline field of the SXVDEx record is equal to 1, this specifies that the pivot field (section 2.2.5.4.3) is in compact axis mode. If the SXAddl_SXCField12_SXDVer12Info record (section 2.4.273.33) is not present, the pivot field (section 2.2.5.4.3) is not in compact axis mode.

The row area can have special entries at the end for grand totals. If there are no pivot fields (section 2.2.5.4.3) and no data field (section 2.2.5.4.9.5.2) on the row axis (section 2.2.5.4.9.2), then the row area is empty.

Show:
© 2015 Microsoft