How do I do step 4

Product Code	Type	Material	Shape	2018	2019	2020
RXGB-117	Prescription	Plastic	Oval	$120	$1,780	$1,490
RXGB-114	Prescription	SS	Oval	$1,090	$880	$1,990
RXPP-103	Prescription	SS	Oval	$1,840	$2,470	$1,250
RXPS-101	Prescription	Titanium	Rectangular	$820	$1,530	$1,520
RXPS-112	Prescription	Titanium	Rectangular	$1,530	$760	$1,750
RXPS-118	Prescription	Plastic	Round	$2,580	$1,540	$1,760
RXPS-122	Prescription	SS	Round	$1,800	$1,590	$940
RXGB-135	Prescription	Plastic	Square	$1,380	$1,920	$1,400
RXPS-136	Prescription	Plastic	Square	$170	$1,800	$1,380
RXPP-182	Prescription	Titanium	Square	$2,910	$1,500	$1,380
Total				$14,240	$15,770	$14,860

PROJECT STEPS 1. Colin Morin is the assistant sales manager for The Optical Boutique. One of his assignments is to format the product sales records from 2018 to 2020 to make it easier to analyze. Switch to the Prescription worksheet. Unfreeze the top row of the worksheet.

2. Sort the data in the PrescriptionSales table first in ascending order by the Material field and then in the ascending order by the Shape field. 3. Insert a Total Row in the PrescriptionSales table, and then use the Total Row to calculate the total of the values in both the 2018 and 2019 fields. (Hint: The Total Row should automatically total the values in the 2020 field.).

4. Colin decides to create a PivotTable to allow him to better manipulate and filter the PrescriptionSales table data. Create a PivotTable based on the PrescriptionSales table in a new worksheet using Prescription PT as the worksheet name. Update the PivotTable as described below so that it matches Final Figure 1:

a. Add the Material field and the Product Code field (in that order) to the Rows area. (Hint: The order of the materials should be Plastic, SS, and Titanium, as shown in Final Figure 1. Sort the PivotTable manually by dragging or by using the Move command if necessary.)

b. Add the 2018, 2019, and 2020 fields (in that order) to the Values area.

c. Update the Sum of 2018 field in the Values area to display the name 2018 Sales with the Accounting number format with 0 decimal places and $ as the symbol.