2.2.5.3.8.1.4 Data Area

The data area contains summarized values for the PivotTable view (section 2.2.5.3). Cells in the data area contain summarized values for associated data items (section 2.2.5.3.7.5.1). The summarized value in a cell is restricted by all the pivot items (section 2.2.5.3.3) in the column (1) area that are located in the same column (1), by all the pivot items in the row area that are located on the same row, and by any page filtering applied, as specified in section 2.2.5.3.7.1.

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