2.2.5.4.10.1.2 Column Area

Office

The column area contains pivot fields (section 2.2.5.4.3), the optional data field (section 2.2.5.4.9.5.2), or both placed on the column axis (section 2.2.5.4.9.3), along with associated pivot items (section 2.2.5.4.4) or data items (section 2.2.5.4.9.5.1). The first row of the column 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, and no pivot fields (section 2.2.5.4.3) are in compact axis mode, and the data field (section 2.2.5.4.9.5.2) is not in compact axis mode, then the pivot field (section 2.2.5.4.3) and data field (section 2.2.5.4.9.5.2) captions are placed sequentially in cells of the first row of the column area according to their placement on the column axis (section 2.2.5.4.9.3).

If the fNoHeaders field of the SXAddl_SXCView_SXDVer12Info record (section 2.4.273.109) is equal to 0, and any pivot field (section 2.2.5.4.3) is in compact axis mode or the data field (section 2.2.5.4.9.5.2) is in compact axis mode, the pivot field (section 2.2.5.4.3) and data field (section 2.2.5.4.9.5.2) captions are placed in the top logical left cell of the column area.

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 record (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 second row in the column area contains pivot item (section 2.2.5.4.4) or data item (section 2.2.5.4.9.5.1) labels for the pivot field (section 2.2.5.4.3) or data field (section 2.2.5.4.9.5.2) placed first on the column axis (section 2.2.5.4.9.3), and each subsequent row contains the pivot item (section 2.2.5.4.4) or data item (section 2.2.5.4.9.5.1) labels for pivot fields (section 2.2.5.4.3) or data fields (section 2.2.5.4.9.5.2) that occur later on the column axis (section 2.2.5.4.9.3). The row containing pivot item (section 2.2.5.4.4) or data item (section 2.2.5.4.9.5.1) labels for the pivot field (section 2.2.5.4.3) or data field (section 2.2.5.4.9.5.2) at position n is row (n +1) of the column area.

If the fNoHeaders field is equal to 1, the pivot field (section 2.2.5.4.3) and data field (section 2.2.5.4.9.5.2) captions are not displayed. The row containing pivot item (section 2.2.5.4.4) or data item (section 2.2.5.4.9.5.1) labels for the pivot field (section 2.2.5.4.3) or data field (section 2.2.5.4.9.5.2) at position n on the column axis (section 2.2.5.4.9.3) is row n of the column area.

The column area can have special entries at the end for grand totals.

Show: