Question: 6 . Marina also wants to insert a PivotTable that includes other Customer information so that she can analyze Family plan customer data. Return to

6. Marina also wants to insert a PivotTable that includes other Customer information so that she can analyze Family plan customer data. Return to the Customers worksheet, and then create a PivotTable based on the Customers table as follows:
a. Place the PivotTable on a new worksheet, and then use Customers Pivot as the name of the worksheet.
b. Display the order location as column headings.
c. Display the state field and then the customer field as row headings.
d. Display the years as the values.
e. Display the plan type as a filter, and then filter the PivotTable to display customer information for Family plans only.
f. Hide the field headers to reduce clutter in the PivotTable.

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 Databases Questions!