Share via

2.2.5.4.10.4 Pivot Line Entries

  • Article

Pivot line entries specify references to the pivot items (section 2.2.5.4.4), data items (section 2.2.5.4.9.5.1), or blank items of a pivot line (section 2.2.5.4.10.3). Pivot line entries are specified by the records that conform to the PIVOTLI rules (section 2.1.7.20.5) in the PIVOTCORE rule (section 2.1.7.20.5). A pivot line entry is an element in the array specified by the rgisxvi field of the SXLIItem structure (section 2.5.259).

All pivot line entries that have an index less than the value specified by the cSic field of the SXLIItem structure (section 2.5.259) of a given pivot line (section 2.2.5.4.10.3) are identical to those of the pivot line (section 2.2.5.4.10.3) preceding the given pivot line (section 2.2.5.4.10.3).

For the purposes of the rest of this section, n specifies a position of the pivot line entry of a given pivot line (section 2.2.5.4.10.3).

If the value of n is less than the cSic field of the SXLIItem structure (section 2.5.259) of a given pivot line (section 2.2.5.4.10.3), then the pivot line entry at position n is identical to the corresponding pivot line entry of the pivot line (section 2.2.5.4.10.3) preceding the given pivot line (section 2.2.5.4.10.3).

If the value of n is greater than or equal to the cSic field of the SXLIItem structure (section 2.5.259) of a given pivot line (section 2.2.5.4.10.3), then the value of n is equal to the sum of the cSic field of the SXLIItem structure (section 2.5.259) and the current index in the rgisxvi field of the SXLIItem structure (section 2.5.259) of the given pivot line (section 2.2.5.4.10.3).

If a pivot line entry is in a pivot line (section 2.2.5.4.10.3) in the row area (section 2.2.5.4.10.1.1), each pivot line entry at a position n specifies a pivot item (section 2.2.5.4.4) index of a pivot item (section 2.2.5.4.4) in the nth pivot field (section 2.2.5.4.3) on the row axis (section 2.2.5.4.9.2) or specifies a data item (section 2.2.5.4.9.5.1) index, if the nth field of the row axis (section 2.2.5.4.9.2) is the data field (section 2.2.5.4.9.5.2).

If a pivot line entry is in a pivot line (section 2.2.5.4.10.3) in the column area (section 2.2.5.4.10.1.2), each pivot line entry at a position n specifies the pivot item (section 2.2.5.4.4) index of a pivot item (section 2.2.5.4.4) in the nth pivot field (section 2.2.5.4.3) on the column axis (section 2.2.5.4.9.3) or specifies a data item (section 2.2.5.4.9.5.1) index, if the nth field on the column area (section 2.2.5.4.10.1.2) is the data field (section 2.2.5.4.9.5.2).

If the nth pivot field (section 2.2.5.4.3) on the row axis (section 2.2.5.4.9.2) or column axis (section 2.2.5.4.9.3) is the data field (section 2.2.5.4.9.5.2), the pivot line entry is a data items (section 2.2.5.4.9.5.1) index, as specified by the Data Items section.

Pivot items (section 2.2.5.4.4) are specified sequentially from logical left to logical right for row pivot lines (section 2.2.5.4.10.3), and from top to bottom for column pivot lines (section 2.2.5.4.10.3).

A value of 0x7FFF is used to specify the absence of a pivot item (section 2.2.5.4.4) or data item (section 2.2.5.4.9.5.1).