Share via

2.2.5.3.7.5.2 Data Field

  • Article

The data field is a conceptual field that represents all data items (section 2.2.5.3.7.5.1) and allows them to be referenced as a single object. The data field is intended to allow all data items to be placed on the row axis or column (1) axis.

If the PivotTable view (section 2.2.5.3) has more than one data item (section 2.2.5.3.7.5.1), then the data field MUST be located on either the row axis, as specified by the rgisxvdrws field of the BrtBeginISXVDRws (section 2.4.97) record, or the column (1) axis, as specified by the rgisxvdcols field of the BrtBeginISXVDCols (section 2.4.96) record. For an OLAP PivotTable (section 2.2.5) that has the data field located on the row axis, the data field MUST be referenced in the rgisxth field of the BrtBeginISXTHRws (section 2.4.95) record. For an OLAP PivotTable that has the data field located on the column (1) axis, the data field MUST be referenced in the rgisxth field of the BrtBeginISXTHCols (section 2.4.94) record.