2.2.5.4.10 PivotTable Layout

The PivotTable report (section 2.2.5) in the sheet (2) has four main areas: the row area (section 2.2.5.4.10.1.1), the column area (section 2.2.5.4.10.1.2), the data area (section 2.2.5.4.10.1.4), and the page area (section 2.2.5.4.10.1.3).

PivotTable report illustrating the four different areas

Figure 15: PivotTable report illustrating the four different areas

All the records described here MUST exist in the same worksheet substream (section 2.1.7.20.5).