2.2.5.4 PivotTable View

  • Article

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

A PivotTable view is specified by the sequence of records that conform to the PIVOTVIEW rule (section 2.1.7.20.5).

Functionality specified by a PivotTable view includes:

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

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

  • Filtering the data in the PivotTable report by performing manual filtering (section 2.2.5.4.7), filtering by criteria (section 2.2.5.4.8), or filtering in the page axis (section 2.2.5.4.9.1).

  • Determining the PivotTable layout (section 2.2.5.4.10).

  • Formatting the entire PivotTable report with a table style (section 2.4.320). See the SXAddl_SXCView_SXDTableStyleClient report (section 2.4.273.107) for details. Alternatively, for an AutoFormat, see section 2.4.313 and section 2.4.315 for details.

  • Formatting an area of the PivotTable report in a way that logically tracks changes in the PivotTable report. For details, see the record specifications for records specified by the PIVOTFORMAT rule (section 2.1.7.20.5).

  • Conditional formatting an area of the PivotTable report in a way that logically tracks changes in the PivotTable report and performs calculations based the fact that the area is in a PivotTable report. For details, see the record specifications for records specified by the SXADDLCONDFMT rule (section 2.1.7.20.5).

  • Sorting pivot items (section 2.2.5.4.4) of pivot fields (section 2.2.5.4.3) within the PivotTable report. For details, see section 2.2.5.4.3.1.