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