Question: 1 7 . Return to the Orders worksheet. In the range H 1 4 :I 1 8 , Eva wants to list the total order

17. Return to the Orders worksheet. In the range H14:I18, Eva wants to list the total order amounts for the five regions where Porter 360 does business. Extract this information from the PivotTable on the Sales by Region worksheet as follows:
a. In cell I14, use the GETPIVOTDATA function to display the total order amount for the Midwest from the PivotTable on the May Sales by Region worksheet (cell B4).(Hint: Type an equal sign in cell I14 and then click the cell containing the value you want the GETPIVOTDATA function to get from the PivotTable.)
b. In cell I15, use the GETPIVOTDATA function to display the total order amount for the Northeast from the PivotTable on the May Sales by Region worksheet (cell B5).
c. In cell I16, use the GETPIVOTDATA function to display the total order amount for the Northwest from the PivotTable on the May Sales by Region worksheet (cell B6).
d. In cell I17, use the GETPIVOTDATA function to display the total order amount for the Southeast from the PivotTable on the May Sales by Region worksheet (cell B7).
e. In cell I18, use the GETPIVOTDATA function to display the total order amount for the Southwest from the PivotTable on the May Sales by Region worksheet (cell B8).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!