2.2.5.4.10.1.4 Data Area

The data area contains summarized values for the PivotTable view (section 2.2.5.4). Cells in the data area contain summarized values for associated data items (section 2.2.5.4.9.5.1). The summarized value in a cell is restricted by all the pivot items (section 2.2.5.4.4) in the column area (section 2.2.5.4.10.1.2) that are located in the same column, by all the pivot items (section 2.2.5.4.4) in the row area (section 2.2.5.4.10.1.1) that are located in the same row, and by any page filter applied, as specified in the Page Axis section.

If the row area (section 2.2.5.4.10.1.1) has a grand total, then the value in that row is not restricted by pivot items (section 2.2.5.4.4) from the row area (section 2.2.5.4.10.1.1). If the column area (section 2.2.5.4.10.1.2) has a grand total, then the value in that column is not restricted by pivot items (section 2.2.5.4.4) from the column area (section 2.2.5.4.10.1.2). If the PivotTable view (section 2.2.5.4) has more than one data item (section 2.2.5.4.9.5.1), then the associated data item (section 2.2.5.4.9.5.1) is the one that is located in the same column in the column area (section 2.2.5.4.10.1.2) or the same row in the row area (section 2.2.5.4.10.1.1) as the cell with the summarized value.

If a PivotTable view (section 2.2.5.4) has zero data items (section 2.2.5.4.9.5.1) then the data area is empty.