Question: The P05_18.xlsx file contains a single-table Data Model on a company's sales and a single blank worksheet: Create a pivot table on the worksheet, based
The P05_18.xlsx file contains a single-table Data Model on a company's sales and a single blank worksheet:
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. What is the Sum of Revenue over the entire month of April? Round your answer to the nearest whole dollar, if necessary.
$
Create a measure, Total Revenue:=Sum([Revenue]), and add it to Values area of the existing pivot table. What is the Total Revenue over the entire month of April? Round your answer to the nearest whole dollar, if necessary.
$
Do you get the same results as in part a?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
