With a regular Break Total line, as described above, the aggregation Data Function that is applied to each Break Total cell is the aggregation Data Function that is already applied to each Fact column.
However, you can explicitly specify an aggregation data function to apply to all cells on a Break Total row. To do this, select the entire Break Total row (by pressing the Alt and mouse left-click buttons simultaneously) and select the appropriate data function from the mouse right-click speed menu or the Pivot menu.
As an example, the row entitled “Total – Average” below, is a regular Break Total line which has had the Average aggregation Data Function explicitly applied to all of its cells (the row entitled “Total” is the regular Break Total row from above):
The "Total - Average" calculates the average value of "Units Sold" from the underlying Table section for all cells, that is, the Total - Average is the aggregated sum of all underlying "Units Sold" values divided by the number of occurrences of "Units Sold" values.
You can see how this concept works across all cells on a Break Total row by reviewing the example below. This example Break Total rows named "Total Sum", "Total - Count", "Total - Max", "Total - Min" which have the Sum, Count, Maximum and Minimum Data Functions respectively forced across their rows:
You can override any cell in a Break Total row which has a forced data function. To override the Break Total Data Function, select the Fact cell in that column and the required data function. As an example, the "Count Of Units Sold" column from above has been selected and the Count data function has been explicitly assigned to this column. The resulting Pivot display is nearly identical to the example above except the entire "Count Of Units Sold" column has its Fact Detail and Break Total cells evaluated by the Count data function as described above:
