IBM Cognos 8 Report Studio Cookbook

Aggregation and rollup aggregation

Business owners want to see the unit cost of every product. They also want the entries to be grouped by product line and see the highest unit cost for each product line. At the end of the report, they want to see the average unit cost for the whole range.

Getting ready

Create a simple list report with Product | Product line, Product | Product name and Sales Fact | Unit Cost as columns.

How to do it...

1. We will start by examining the Unit Cost column. Click on this column and check the Aggregate Function property.
2. Set this property to Average.
3. Add grouping for Product line and Product names, by selecting those columns and hitting the GROUP button from toolbar.
4. Click on the Unit Cost column and click on the Aggregate ...