Database Reference
In-Depth Information
Table 11-3.
A Description of the AggregationFunction Settings
Aggregation Function
Description
Sum
Adds values for all individual measure values into a total.
Count
Provides a count of all individual measure values.
Min
Returns the lowest value of all individual measure values.
Max
Returns the highest value of all individual measure values.
DistinctCount
Returns a count of all unique individual measure values.
None
No aggregation is performed, and null is used for places where subtotals would
normally display. (It is useful for items such as the Author Order in our example.)
ByAccount
Calculates the aggregation according to an assigned custom aggregation
function. (Used only for special account dimensions.)
AverageOfChildren
Returns an average of values for all nonempty individual measure values.
FirstChild
Returns the value of the first child member under a given parent. (For example, an
inventory count measure on January 1 would be the first child under the parent
January. So, you would see the inventory count for the first day of that January but
not the total of all the other days.)
LastChild
Returns the value of the last child member under a given parent.
FirstNonEmpty
Retrieves the value of the first nonempty child member under a given parent. For
example, if January 1 had no inventory values but January 2 did, you would see
the value for the second day of January.
LastNonEmpty
Retrieves the value of the last nonempty child member under a given parent.
The FormatString property uses the same style of format notation as Excel spreadsheets. In this property, you
can specify how you want the data to display to the client. Most client software will respect this, but some may
not. In those cases, the formatting will have to be reapplied at the report level. In Figure
11-20
, we show the list of
predefined options, but you can type in your own as well.
Figure 11-20.
Setting the FormatString property
