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.