The example below shows a simple Pivot section with detail cell values only (no break totals and surface values have been disabled). (Unless otherwise specified, this Table section is used as the source data for Pivot section examples shown throughout this appendix.)
Review the Table section below that shows values of "Units Sold" for some sample cities in the USA. The visible Fact values for each City in the Pivot section are equivalent to the sum of each City's individual constituent "Units Sold" values in the underlying Table section.
In other words the Row Label of Los Angeles and the Pivot-displayed "Units Sold" value of 1,100 have been evaluated by summing each "Units Sold" value for Los Angeles in the underlying Table section (i.e. 500 + 400 + 100 + 100 = 1,100).
In addition to the sum method for aggregation in the Pivot section, you can explicitly specify a number of other aggregation methods, or Data Functions, in which to collect and represent the underlying Table section data as Facts in the Pivot section. These Data Functions include:
Average—The displayed Pivot Fact value is the average (mean) value of the Fact values for this Pivot Row Label in the underlying Table section (i.e. the sum of the corresponding values in the Table section divided by the number of occurrences (rows) of these values).
Count—The displayed Pivot Fact value is the sum of the number of occurrences of Fact values for this Row Label in the underlying Table section.
Maximum—The displayed Pivot Fact value is the maximum value of all Fact occurrences in the underlying Table section for this Row Label.
Minimum—The displayed Pivot Fact value is the minimum value of all Fact occurrences in the underlying Table section for this Row Label.
The effect of applying the above different aggregation Data Functions on Pivot Fact columns can be illustrated in the following Pivot section:
The "Units Sold" Fact column is evaluated using a Sum Data Function as above, whereas the "Average Of Units Sold" column uses the Average aggregation Data Function.
That is, the "Average Of Units Sold" Fact value for Los Angeles is evaluated according to the following formula:
The Sum of "Units Sold" values for Los Angeles in the underlying Table section divided by the number of occurrences (rows) of "Units Sold" values for Los Angeles in the underlying Table section
(500 + 400 + 100 + 100) / 4 = 1100/4 = 275
The "Count Of Units Sold" value for Los Angeles is 4, which is evaluated by using the Count aggregation Data Function. It is equal to the count or number of individual "Units Sold" row occurrences for Los Angeles in the underlying Table section
The "Max Of Units Sold" for Los Angeles is 500, which is evaluated using the Maximum aggregation Data Function. This function returns the maximum single "Units Sold" value from all "Units Sold" values for Los Angeles in the underlying Table section.
The "Min Of Units Sold" for Los Angeles is 100, which is evaluated using the Minimum aggregation Data Function. This returns the minimum single "Units Sold" value from all "Units Sold" values for Los Angeles in the underlying Table section.