Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Go to the Purchases by Year worksheet. The PivotTable on this worksheet lists the purchase prices of the collectibles by year and categoly. Anthony wants
Go to the Purchases by Year worksheet. The PivotTable on this worksheet lists the purchase prices of the collectibles by year and categoly. Anthony wants to show the names of each collectible item and display the information about the two categories with the highest total purchase prices:
Provide this information For Anthony as follows:
a Expand the Category field to show the name of each item.
b Apply a Value Filter to the Category field that displays the top items by the
so sum of purchase price.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started