# The P04_14.xlsx file contains the Contoso Data Model discussed in Example 4.4, but without any calculated columns,

## Question:

The P04_14.xlsx file contains the Contoso Data Model discussed in Example 4.4, but without any calculated columns, measures, or hierarchies:

a. In the Sales table, create two calculated columns: Net Revenue as SalesAmount minus ReturnAmount and Cost without Overhead as 0.95 times TotalCost. Then create a pivot table with ProductCategoryName in the Rows area and the two calculated columns in the Values area, each summarized by Sum.

b. In the Sales table, create two measures: Total Net Revenue as Sum of Net Revenue and Total Cost without Overhead as Sum of Cost without Overhead. Then create a pivot table (on a new sheet) with ProductCategoryName in the Rows area and the two measures in the Values area.

c. Do these two pivot tables give the same results? Are there any differences between them? Which requires more calculations? Explain.

## Step by Step Answer:

**Related Book For**

## Business Analytics Data Analysis And Decision Making

**ISBN:** 9780357109953

7th Edition

**Authors:** S. Christian Albright, Wayne L. Winston