Users want to see product lines, products, and corresponding unit costs. For every product, they also want to see the trend of sales over last year.
We need to produce a list report with required information and nest a line chart within it to show the sales trend.
Create a simple list report based on the Sales (query) namespace. Pull Product | Product line, Product | Product name and Sales fact | Unit cost in the list.
We already have a list report that shows the product lines, products, and corresponding unit costs. Please make sure that appropriate sorting and aggregations are applied to the columns.
Now we will add a nested Chart object to show the sales trend for each product.
Drag a new Chart object from the Insertable Objects pane onto the report as a column.
Choose an appropriate chart type. In this recipe, we will choose "Line with Markers".
From Source pane, drag Quantity from Sales fact onto the chart...