Creating nested report: Defining master detail relationship
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.
Getting ready
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.
How to do it...
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...
