2.2.5.3.3 Pivot Items

Office

Pivot items represent specific instances of the entities represented by pivot fields (section 2.2.5.3.2). Each pivot item specifies its display properties. For example it can contain the user defined caption for the pivot item or information about whether the pivot item is hidden or not.

A pivot item is specified by the sequence of records that conform to the SXVI rule (as defined in section 2.1.7.40). A pivot item is contained in a pivot field. The collection specified by the sequence of records that conform to the SXVIS rule (as defined in section 2.1.7.40) specifies the pivot items of a pivot field.

A pivot item can be referenced by a pivot item index. A pivot item index is specified to be the zero-based index of an SXVI rule in the collection specified by the SXVIS rule.

A pivot item can be associated with a cache item (section 2.2.5.2.3). The iCache field of the BrtBeginSXVI (section 2.4.265) record of the pivot item specifies the cache item index of the associated cache item in the associated cache field (section 2.2.5.2.2). If the itmtype field of this BrtBeginSXVI record is not PITDATA (section 2.5.104), then this pivot item MUST NOT have an associated cache item. Two pivot items MUST NOT be associated with the same cache item. Note that although a pivot field (section 2.2.5.3.2) index references a pivot field that corresponds to the cache field with the same cache field index, a pivot item index might not reference a pivot item that corresponds to a cache item with the same cache item index.

The number of pivot items, where the itmtype field of the BrtBeginSXVI (section 2.4.265) record of the pivot item is PITDATA (section 2.5.104), MUST equal zero or the number of cache items in the cache field of the pivot field (section 2.2.5.3.2).

Show: