126.96.36.199.3 Pivot Fields
A pivot field is specified by a sequence of records that conforms to the PIVOTVD rule (section 188.8.131.52.5) and optionally the PIVOTVDTEX (section 184.108.40.206.5) and SXADDLFIELD (section 220.127.116.11.5) rules. The PIVOTVDTEX rule specifies additional properties for OLAP PivotTable views (section 18.104.22.168.2), and the SXADDLFIELD rule (section 22.214.171.124.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 126.96.36.199.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 188.8.131.52.5. The number of pivot fields in the sequence of records that conforms to a PIVOTCORE rule (section 184.108.40.206.5) MUST be equal to the number of cache fields in the associated PivotCache (section 220.127.116.11.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 18.104.22.168.9) and data items (section 22.214.171.124.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.