Anthony wants to know the difference and the percentage of difference between the purchase prices and the current values.

Provide this information for Anthony as follows:

a$.$ Insert a calculated field named Difference that subtracts the Purchase Price field amount from the Current Value field amount.

b$.$ Insert another calculated field named $\%$ Difference that subtracts the Purchase Price field amounts from the Current value field amounts, and then divides the result by the Purchase Price field amount.

c$.$ Change the number format of the Sum of $\%$ Difference amounts to Percentage with $2$ decimal points.

Anthony also wants to include the average purchase price for the items in each category as the last column in the PivotTable.

Add this information to the PivotTable as follows:

a$.$ Add the Purchase Price field to the Values area of the Pivotiable, making it the last field in the Values area.

b$.$ Use the Average calculation to summarize the Purchase Price field data.