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.
Create a simple list report with Products / Product line, Products/Product, and Sales fact / Unit cost as columns.
How to do it...
In this recipe, we want to examine how to aggregate the data and what is meant by rollup aggregation. Using the new report that you have created, this is how we are going to start this recipe:
- We will start by examining the Unit cost column. Click on this column and check the Aggregate Function property.
- Set this property ...