1 Open exploring _ e05 _ grader _ h3 _ Fiesta. xlsx and save it 0.000 asexploring _ e05 _ grader _ h3 _ Fiesta _ LastFirst. xlsx.
2 Create a blank PivotTable from within the Items table to
10.000 analyze multiple tables. Place the PivotTable on a new worksheet and name the worksheet Retired Colors.
3 Display the names of both tables in the PivotTable
12.000
Fields task pane. Display the Color names as ROWS and the sum of the Replacement Value field as VALUES. Create a relationship between the Items table using the Color Number field and the Colors table using the Number field.
4 Add a Report FILTER to display aggregates for retired
12.000 colors only( use the Retired field). Note that current colors do not have a retirement date, so you must filter out the blanks.
5 Apply the Pivot Style Medium 7. 5.000