Return to the "Client Sales Report" tab and, using the ribbon, clear the filter. Create a Pivot Table and have it placed on a new worksheet. Accept all defaults and label the tab "Pivot Table Analysis 1". Move the Pivot Table worksheet to position 4. Creating a Pivot Table will require that you use "Destinations" in the "Rows" quadrant, "Agent" in the "Column" quadrant and "Trip Revenue" in the "Values" quadrant. Update the Pivot Table data in the Accounting format with zero decimals