Referring to Exercises 18-13 through 18-17, create a new column called Sales Margin in the SalesData table

Question:

Referring to Exercises 18-13 through 18-17, create a new column called Sales Margin in the SalesData table that is the difference between ListPrice and UnitPrice. Note that ListPrice is found in the ProductData table, so you will need to use the RELATED command. Once you have created the new column, set the column, format as General Currency with two decimal places, and create a clustered column chart that shows the average Sales Margin by Territory Group for the orders that Bordon’s received this month. Add a title and data labels to the chart.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Business Statistics A Decision Making Approach

ISBN: 9780134496498

10th Edition

Authors: David F. Groebner, Patrick W. Shannon, Phillip C. Fry

Question Posted: