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:

  • If the previous pivot field (section 2.2.5.4.3) or data field (section 2.2.5.4.9.5.2) is not in compact axis mode, then pivot items (section 2.2.5.4.4) or data items (section 2.2.5.4.9.5.1) of the current pivot field (section 2.2.5.4.3) or data field (section 2.2.5.4.9.5.2) are placed in the next column of the row area. Pivot items (section 2.2.5.4.4) or data items (section 2.2.5.4.9.5.1) are grouped by the parent pivot item (section 2.2.5.4.4) or data item (section 2.2.5.4.9.5.1), which is the pivot item (section 2.2.5.4.4) or data item (section 2.2.5.4.9.5.1) on the immediate logical left. To achieve this, pivot items (section 2.2.5.4.4) or data items (section 2.2.5.4.9.5.1) of the parent pivot field (section 2.2.5.4.3) or data field (section 2.2.5.4.9.5.2) can be repeated multiple times. In this case, when pivot items (section 2.2.5.4.4) or data items (section 2.2.5.4.9.5.1) are repeated, the caption is not necessarily displayed in every cell that contains a pivot item (section 2.2.5.4.4) or data item (section 2.2.5.4.9.5.1). For more details, see the Pivot Lines section.

  • If the previous pivot field (section 2.2.5.4.3) or data field (section 2.2.5.4.9.5.2) is in compact axis mode, then the pivot items (section 2.2.5.4.4) or data items (section 2.2.5.4.9.5.1) of the current pivot field (section 2.2.5.4.3) or data field (section 2.2.5.4.9.5.2) are placed in the same column as pivot items (section 2.2.5.4.4) of the previous pivot field (section 2.2.5.4.3) or data field (section 2.2.5.4.9.5.2). Pivot items (section 2.2.5.4.4) or data items (section 2.2.5.4.9.5.1) are grouped by the parent pivot item (section 2.2.5.4.4) or data item (section 2.2.5.4.9.5.1) and placed immediately under the parent pivot item (section 2.2.5.4.4) or data item (section 2.2.5.4.9.5.1).

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:
© 2016 Microsoft