You have created reports that show the total inventory for each product by category number. Suppose that you also want to know what products and product categories are most and least profitable to the company so that you can make recommendations about the mix of products that the company should continue to sell. You want the reports to show the following information:
The data that you need in order to create this report is contained in several different tables. Using the Query Builder, you can join the tables that contain this information, and then you can run tasks on the query output. You need to join the following tables:
None of the tables contain profit data, but you can add a computed column for profit in the query.
|Next you start a query and add the tables that you need.|