Microsoft Office Tutorials and References
In Depth Information
FIguRE 8-17 When you select different aggregation functions, you get different results.
Obviously, you can use other aggregators in different situations. Although COUNT is frequently
used to get the number of rows (as can be the case for the number of orders or the number of
products sold), MIN and MAX can be useful, for example, to get the minimum and maximum
discounted price of a product sold over time or, as in the example, for weights.
This procedure is easy to follow if you have a measure that should be aggregated with a
specific function. Nevertheless, if you want an easier model, it is better to define a new
measure that already contains the aggregation function instead of changing the default
aggregator each time you need to add it to a report. Moreover, after you define the new
measure, if the aggregation with SUM is not meaningful, you can hide the original column
from the PivotTable so that you can select only the measure with the correct aggregation.
In our example, you can easily define a new measure, as you see in Figure 8-18.
FIguRE 8-18 A new calculated measure is useful for automatically choosing the correct aggregator.