Go to the Items by Category worksheet. Anthony created a PivotTable that lists each item by category and then counts the number of those items acquired each year. The data is sorted in alphabetic order by category, but Anthony wants to sort the data by the total number of items. He also wants to focus on coins and comic books only. Change the display of the PivotTable as follows:

a. Sort the data in descending order by Grand Total.

 

A B Comic books Movies Sports Toys Grand Total Count of Items Year Acquired Category Coins Romano Collectibles C D E F G 3 2016 2017 2018 2019 2020 2021 Grand Total 1 2 2 1 1 1 2 11 1 2 1 1 6 6 2 1 6 3 1 1 9 5 H 2 5 7 10 3 33