2.2.5.4.9.5.1 Data Items

Office

A data item is a pivot field (section 2.2.5.4.3) placed on the data axis (section 2.2.5.4.9.5). Each data item is specified by an SXDI record (section 2.4.278).

The isxvdData field of the SXDI record (section 2.4.278) specifies a reference to the pivot field (section 2.2.5.4.3) that is associated with a data item. It also specifies additional information that is used to produce or present summarized values.

A data item can be referenced by a data item index, which is the zero-based index of an SXDI record (section 2.4.278) in the sequence of records that conforms to the PIVOTCORE rule (section 2.1.7.20.5) as defined by the Worksheet Substream ABNF.

Show: