3.8 PivotTable

This example shows a PivotTable (section 2.1.7.40) and its associated PivotCache (section 2.2.5.2). The PivotTable uses a range of cells (A1:E45) in the "Source Data" sheet as its source data (section 2.2.5.2.1). The "CustomerName" and "ProductName" fields have been added to the row area, "Quantity" to the data area (section 2.2.5.3.8.1.4), and "OrderDate" to the page area (section 2.2.5.3.8.1.3) of this PivotTable view (section 2.2.5.3). The "OrderDate" field has two dates selected in the filter (12/23/1997 and 12/26/1997) and the rest have been filtered out.

The following figure illustrates the PivotTable (section 2.1.7.40) discussed in this example.

Figure 26: PivotTable example

This example covers PivotTable records that are members of the Workbook (section 2.1.7.61), PivotCache Definition (section 2.1.7.38), PivotCache Records (section 2.1.7.39), and PivotTable (section 2.1.7.40) parts ABNF. The first set of records between BrtBeginPivotCacheIDs (section 2.4.170) and BrtEndPivotCacheIDs (section 2.4.520) are contained in the Workbook part ABNF. The records between BrtBeginPivotCacheDef (section 2.4.168) and BrtEndPivotCacheDef (section 2.4.518) are contained in the PivotCache Definition part ABNF. The records between BrtBeginPivotCacheRecords (section 2.4.171) and BrtEndPivotCacheRecords (section 2.4.521) are contained in the PivotCache Records part ABNF. The records between BrtBeginSXView (section 2.4.275) and BrtEndSXView (section 2.4.625) are contained in the PivotTable (section 2.1.7.40) part ABNF.