1. Create a new measure named Sales Tax by using the appropriate Expression to multiply the Sold Price from the Inventory table by the State Tax from the related Location table . Format Sales Tax as a whole number, 0 decimal. 2. Create a new measure named Gain /Loss by using the appropriate Expression to subract the SUM of the Sold Price from the SUM of the List Price . Format Gain /Loss as a whole number, 0 decimal 3. Create a new Report. On Page 1, create the following visualizations 1. Table Visualization: Add the following fields and measure to the table visual: Model Year, Sold Price , Sales Tax. Format the Table Visual: Font: Segoe , Size of Data Values: 15 pt, Column Headers : 14 pt. Adjust columns as required to show all data . Enter yes , if completed 2. Clustered Column Chart Visualization . Add the following fields to the chart : Model Year, Sold Price, Sales Tax. Format the Sold Price Data color: #9071ce , Theme color 6, 20 % lighter. Enter yes , if completed 3. Apply the following Advanced Filter to the Page to show data for Model Years 2017 and after . Enter yes , if completed Rename Page 1 your First and Last Name , for example John Brown What is the total Sold Price for the filtered Model Years? What is the total Sales Tax for the filtered Model Years? 4. Add a new Page to the Report On Page 2, create the following visualizations 1. Table Visualization: Add the following fields and measure to the table visual: Location ID Sold Price , Sales Tax. Format the Table Visual: Font: Segoe , Size of Data Values: 15 pt, Column Headers : 14 pt. Adjust columns as required to show all data . Enter yes , if completed 2. Pie Chart Visualization . Add the following fields to the chart : Location ID , Sold Price . Format the larger slice of the Pie Data color : #elc233, Theme color 7, 20% lighter. Enter yes , if completed 3. Apply the following Filter to the Page to show data for Location ID : LOCO1 and LOC04 Enter yes , if completed What is the total Sold Price for the filtered Location ID