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
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 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
