22.214.171.124.3 Pivot Fields
A pivot field is specified by a sequence of records that conforms to the PIVOTVD rule (section 126.96.36.199.5) and optionally the PIVOTVDTEX (section 188.8.131.52.5) and SXADDLFIELD (section 184.108.40.206.5) rules. The PIVOTVDTEX rule specifies additional properties for OLAP PivotTable views (section 220.127.116.11.2), and the SXADDLFIELD rule (section 18.104.22.168.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 22.214.171.124.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 126.96.36.199.5. The number of pivot fields in the sequence of records that conforms to a PIVOTCORE rule (section 188.8.131.52.5) MUST be equal to the number of cache fields in the associated PivotCache (section 184.108.40.206.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 220.127.116.11.9) and data items (section 18.104.22.168.9.5.1) referring to pivot fields.
The following figure shows a PivotTable report with three pivot fields displaying Sales by Country and Fiscal Year.