Cognos Report Studio

[shadowhunter]

In cognos report studio, we can specify aggregation type such as Total, Minimum, etc. for query items in a query subject
What is the purpose of "calculation" aggregation type ?  Under which scenario will we use it practically? Request to explain with example.

[MFGF]

In cognos report studio, we can specify aggregation type such as Total, Minimum, etc. for query items in a query subject
What is the purpose of "calculation" aggregation type ?  Under which scenario will we use it practically? Request to explain with example.

It's typically used where you want to perform an aggregation than is calculated from other aggregations.

Consider a list with three columns from your package - Product, Revenue and Target. You then add a fourth calculated column to your list - % Of Target, which divides Target by Revenue (and formats as %). Now you want aggregates at the end of your list. Assuming both Revenue and Target are set to Sum, you have two options for the calculated column:
1. Set it to Sum also. This will add up all the percentages in the column and provide a rather ridiculous value in your footer.
2. Set it to Calculated. This will take the Revenue and Target aggregated values from the footer and use them to calculate the overall % Of Target.

MF.

[shadowhunter]

Thanks MF for the update