(Based on the North wind database) Create an appropriate query that allows you to see the total revenue broken down by any of product name, product category, month-year of order date, or customer. Here revenue is defined as Unit Price*Quantity*(1-Discount), where these fields all come from the Order Details table. You can do this in either of two ways. First, you can return all of the data as a table, then use an Excel formula to calculate revenue for each row, and finally use a pivot table to get the desired results. Second, you can create a calculated field Revenue in Microsoft Query and return the results as a pivot table. (The latter is actually preferable because a pivot table takes up less room in Excel. Imagine if there were millions of rows in the Order Details table. They wouldn’t fit in Excel if you tried to bring them in as a table, but this isn’t a problem with a pivot table.)

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now


"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"