Alex wants to compare the Platinum group data for January by specialty. He asks you to create a PivotTable to better manipulate and filter the data. On a new worksheet, create a recommended PivotTable based on the Platinum table that shows the Sum of Jan by Specialty. [Mac Hint - Insert a new PivotTable on a new worksheet, adding the Specialty field to the Rows area and the Jan field to the Values area.] Use Platinum PivotTable for the name of the worksheet containing this PivotTable. Apply Rose, Pivot Style Medium 13 to match the style of the other tables in the workbook. 10. 11. Alex asks you to customize the new PivotTable to show more details and to provide a filter. Add the Total Projects field to the Values area below the Sum of Jan field. Add the Group ID field to the Rows area below the Specialty field. Add the Project Type field to the Filters area. Change the display of subtotals to Show all Subtotals at Bottom of Group. Alex also wants to focus on data for repeat projects only and to display the records for reviews. Filter the PivotTable to show only records with a Repeat project type. Drill down into cell C15 to show all records for Reviewing projects with a Repeat project type on a new worksheet. Use Repeat Reviews as the name of the new worksheet. Apply Red, Table Style Medium 6 to the table. 12. Editing Groups - Platinum Level 1. 2. 3. Specialty Project Type Projects Mar - 4. Group ID Level Jan Total Projects Feb 5. A-2 Platinum Reviews New 10 8. 11 29 6. Repeat Copywriting Repeat A-1 Platinum Q&AS 7 8. 9 24 7 B-2 Platinum 10 7. 7 24 C-1 Platinum Internal New 6. 9. 22 9. B-3 Platinum Reviews 6. 6. 20 Repeat Copywriting Repeat 8 10 C-3 Platinum 6. 20 11 A-3 Platinum Internal New 5. 7. 7. 19 Platinum Q&As 7 7. 19 Repeat Repeat 12 -1 13 C-2 Platinum Reviews 6. 6. 6. 18 14 15 Most projects: 16 17 Total reviews: