Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All Pivot Fields


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

A pivot field is specified by a sequence of records that conforms to the PIVOTVD rule (section and optionally the PIVOTVDTEX (section and SXADDLFIELD (section rules. The PIVOTVDTEX rule specifies additional properties for OLAP PivotTable views (section, and the SXADDLFIELD rule (section 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

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 The number of pivot fields in the sequence of records that conforms to a PIVOTCORE rule (section MUST be equal to the number of cache fields in the associated PivotCache (section 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 and data items (section referring to pivot fields.

A pivot field can have pivot items (section A pivot field can describe information such as pivot field sorting (section and subtotaling (section 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

© 2015 Microsoft