The method by which the underlying Table section values are aggregated/collected into Pivot section Facts can be varied by a user. As a default, the aggregation method is to sum the data (as shown in the Pivot example above); that is, the underlying Fact values are added together and the sum displayed as the Pivot Detail Fact cell value. There are several other aggregation Data Functions that can be applied to a Pivot Detail cell.
An aggregation Data Function can be applied to all Pivot Fact cells across a row or to the Fact cells down a column.