2.2.5.3.2 Pivot Fields

A pivot field corresponds to a cache field (section 2.2.5.2.2). A pivot field specifies display information of the data in the PivotTable view.

A pivot field is specified by the sequence of records that conform to the SXVD rule (defined in section 2.1.7.40). A pivot field is contained in the PivotTable view. A PivotTable view contains a collection of pivot fields which is specified by the SXVDS rule (defined in section 2.1.7.40).

A pivot field index, which identifies a pivot field, is specified to be the zero-based index of a sequence of records that conform to the SXVD rule in the sequence of records that conforms to the SXVDS rule.

Each pivot field is associated with the cache field (section 2.2.5.2.2) with a cache field index equal to the pivot field index of the pivot field. For more details, see section 2.2.5.2.2. The number of pivot fields in the PivotTable view (section 2.2.5.3) MUST equal the number of cache fields in the associated PivotCache (section 2.2.5.2).

The principal way that the structure of a PivotTable view is used to create a PivotTable report is that pivot fields can be part of PivotTable axes (section 2.2.5.3.7). Also, a data item (section 2.2.5.3.7.5.1) can refer to a pivot field.

A pivot field can have pivot items (section 2.2.5.3.3). A pivot field can describe various information such as pivot field sorting (section 2.2.5.3.2.1) and subtotaling (section 2.2.5.3.7.4.2) settings.

The following figure illustrates a PivotTable (section 2.2.5) report with four pivot fields displaying Sales by Product, Country/Region, and Date.

Figure 13: PivotTable report with four pivot fields