Question: 1 7 . Return to the Orders worksheet. In the range H 1 4 :I 1 8 , Eva wants to list the total order
Return to the Orders worksheet. In the range H:I Eva wants to list the total order amounts for the five regions where Porter does business. Extract this information from the PivotTable on the Sales by Region worksheet as follows:
a In cell I use the GETPIVOTDATA function to display the total order amount for the Midwest from the PivotTable on the May Sales by Region worksheet cell BHint: Type an equal sign in cell I and then click the cell containing the value you want the GETPIVOTDATA function to get from the PivotTable.
b In cell I use the GETPIVOTDATA function to display the total order amount for the Northeast from the PivotTable on the May Sales by Region worksheet cell B
c In cell I use the GETPIVOTDATA function to display the total order amount for the Northwest from the PivotTable on the May Sales by Region worksheet cell B
d In cell I use the GETPIVOTDATA function to display the total order amount for the Southeast from the PivotTable on the May Sales by Region worksheet cell B
e In cell I use the GETPIVOTDATA function to display the total order amount for the Southwest from the PivotTable on the May Sales by Region worksheet cell B
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
