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
Business Statistics A Decision Making Approach
ISBN: 9780134496498
10th Edition
Authors: David F. Groebner, Patrick W. Shannon, Phillip C. Fry
Question Posted: