Question: 1 . Go to the Project Types by Year worksheet. The PivotTable on this worksheet lists the final costs of the building projects by year

1. Go to the Project Types by Year worksheet. The PivotTable on this worksheet lists the final costs of the building projects by year and type. Camille wants to show the names of each project and display the information about the two project types with the highest total final cost.
Provide this information for Camille as follows:
a. Expand the Project Type field to show the names of each project.
b. Apply a Value Filter to the Project Type field that displays the top 2 items by the sum of final cost.

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