The P04_18.xlsx file contains a single-table Data Model on a companys sales and a single blank worksheet:

Question:

The P04_18.xlsx file contains a single-table Data Model on a company’s sales and a single blank worksheet:
a. Create a pivot table on the worksheet, based on the Data Model, and drag Revenue to the Values area and Date to the Rows area.
b. Create a measure, Total Revenue:=Sum([Revenue]), and add it to Values area of the existing pivot table. Do you get the same results as in part a? Explain.

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

Step by Step Answer:

Related Book For  book-img-for-question

Business Analytics Data Analysis And Decision Making

ISBN: 9780357109953

7th Edition

Authors: S. Christian Albright, Wayne L. Winston

Question Posted: