Cogbnos

• Jul 17th, 2011

 

Aggregate Function: This function specifies what type of Aggregation to be applied on a data item. The Aggregation can be of the types "Total", "Average", "Minimum", "Maximum" etc.

Roll Up Aggregation: One above you have determined what type of aggregation you are applying on a data item e.g. Unit cost then here you can decide about the type of aggregation on the summarized values. In case of our Unit cost, if you have applied "Aggregate" choose here as "Maximum". Remember "The roll-up aggregation of any item is important only when you create the aggregation of 'Aggregate' type. Otherwise leave it as automatic.

shailendra32

 Profile Answers by shailendra32 

• Jul 23rd, 2011

 

Aggregate Function

Specifies the type of aggregation to apply. The Automatic setting means that the application groups or summarizes based on the data type. The Summarize setting means that any setting found in the model will be used to determine the type of aggregation. The default setting is Automatic.

Rollup Aggregate Function

Specifies the type of aggregation to apply to summarized values. These values appear at the higher levels of lists and crosstabs.


Say, you have Product line - grouped, Product type, and Quantity in a list report. Aggregate function defines how you want the quantity be aggregated for product type.
Versus, the rollup aggregate function will define how you want your quantity be aggregated for Product line. Try it yourself and play with the different options available for the aggregate/or rollup aggregate functions (total, min, max, ave, none...etc).