Open the EX2019-IndependentProject-10-6 start file. Click the Enable Editing but

Open the EX2019-IndependentProject-10-6 start file. Click the Enable Editing button. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. Launch Power Pivot. Import the Text-BoydAir10.txt file from your downloaded from the Resources link. Use the first row as column headers. Get the TblBoydAir table from the Microsoft Access Database-10 downloaded from the Resources link. NOTE: If you receive a Security Warning message, click OK and continue on to the next step. Create a relationship using the date field as the common field.
Create a PivotTable from the Power Pivot data model in cell A1 in your existing worksheet. Name the worksheet PivotTable. Display the Flight and the FlightDate fields from TblBoydAir in the Rows area with the Flight field first. If the date field separates to include months or quarters, drag unnecessary field names out of the PivotTable Fields pane to remove them. Display the Passengers field in the Values area. Choose tabular form for the report layout. Place the Code field from the Text-BoydAir10 list. It is a Rows field. Insert a slicer for the Arrival field. Apply White, Pivot Style Medium 15 style to the PivotTable and White, Slicer Style Dark 3 to the slicer. Filter the data for GRB (Figure 10-86). Position the slicer in the top left corner of cell F2 as shown in the figure. Save and close the workbook. Upload and save your project file.