4. Use the data in the sheet titled "Raw data" to calculate the prot for each product category and product sub category (ability to drill down). a. Create a new worksheet titled \"Q4 Prot by Category\" and insert a new pivot table for the data in the sheet \"Raw Data". Move the worksheet to the 4th position. List the total prot for product categories and subcategories in this table . Format the numbers to reflect the "$" symbol before the gures and 2 decimal places. . Change the column headings to be meaningful. . Add a meaningful title to the worksheet at the top and center it across the pivot table. Use conditional bars to highlight gains and losses. K 3 m Libel: 3 Sum of Profit 4_ E! ru Rulrqu I] 5241.52 5 A Booxoxsss 6042.15 6 CHAIRS 81 CHAIRMATS 7245.16 . Add another column to the pivot table display the prot or loss as a percent of the total. . Use conditional formatting to display the top 3 products that had the highest percentage