2.2.5.3 PivotTable View

  • Article

A PivotTable view is a set of structures that specify layout, filtering, sorting, and other properties. These properties are used to produce a PivotTable (section 2.2.5) report based on data from the PivotCache (section 2.2.5.2).

A PivotTable view is specified by the sequence of records that conforms to the PIVOTTABLE rule (defined in section 2.1.7.40).

An OLAP PivotTable view has an associated PivotCache (see section 2.2.5.3.1) that is an OLAP PivotCache (section 2.2.5.2).

Functionality specified by a PivotTable (section 2.2.5) view includes:

  • The arrangement of pivot fields (section 2.2.5.3.2) on the row axis, column (1) axis, or both to produce a PivotTable report.

  • Using data items (section 2.2.5.3.7.5.1) on the data axis (section 2.2.5.3.7.5) to show summarized result values in the PivotTable report.

  • Filtering data in the PivotTable report by performing manual filtering (section 2.2.5.3.5), filtering by criteria (section 2.2.5.3.6), or filtering in the page axis (section 2.2.5.3.7.1).

  • Determining the PivotTable layout (section 2.2.5.3.8).

  • Formatting the entire PivotTable report with a tables style (section 2.2.6.3). See section 2.4.834 for details.

  • Formatting an area of the PivotTable report in a way that logically tracks changes in the PivotTable report. Formatting settings are associated with logical parts of the PivotTable view, and not with fixed ranges on the sheet. See the sequence of records conforming to the SXFORMAT rule (defined in section 2.1.7.40) for details.

  • Conditional formatting an area of the PivotTable report in a way that logically tracks changes in the PivotTable report and performs calculations based on the fact that the area is in a PivotTable report. See the sequence of records conforming to the SXCONDFMT rule (defined in section 2.1.7.40) for details.

  • Sorting pivot items (section 2.2.5.3.3) of pivot fields (section 2.2.5.3.2) within the PivotTable report. For details, see section 2.2.5.3.2.1.

Non-OLAP PivotTable views enable the creation of different PivotTable reports associated with the same PivotCache. This enables the creation of different visual representations without duplicating the PivotCache.