2.2.5.4.3 Pivot Fields

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

A pivot field is specified by a sequence of records that conforms to the PIVOTVD rule (section 2.1.7.20.5) and optionally the PIVOTVDTEX (section 2.1.7.20.5) and SXADDLFIELD (section 2.1.7.20.5) rules. The PIVOTVDTEX rule specifies additional properties for OLAP PivotTable views (section 2.2.5.4.2), and the SXADDLFIELD rule (section 2.1.7.20.5) specifies additional version specific properties. A pivot field is contained in the PivotTable view. A PivotTable view contains a collection of pivot fields which is specified by the sequence of records that conforms to the PIVOTVIEW rule (section 2.1.7.20.5).

A pivot field index, which identifies a pivot field, is specified as the zero-based index of a PIVOTVD rule in the collection specified by a PIVOTVIEW rule.

Each pivot field is associated with the cache field with a cache field index equal to the pivot field index of this pivot field. For more details, see section 2.2.5.3.5. The number of pivot fields in the sequence of records that conforms to a PIVOTCORE rule (section 2.1.7.20.5) MUST be equal to the number of cache fields in the associated PivotCache (section 2.2.5.4.1) for the PivotTable view.

A PivotTable view is used to create a PivotTable report (section 2.2.5). This can include information about pivot fields placed on PivotTable axes (section 2.2.5.4.9) and data items (section 2.2.5.4.9.5.1) referring to pivot fields.

A pivot field can have pivot items (section 2.2.5.4.4). A pivot field can describe information such as pivot field sorting (section 2.2.5.4.3.1) and subtotaling (section 2.2.5.4.9.4.2) settings.

The following figure shows a PivotTable report with three pivot fields displaying Sales by Country and Fiscal Year.

Figure 13: PivotTable report with three pivot fields: Sales, Country, and Fiscal Year