Instructions$---$ DO NOT HARDCODE ANYTHING

$1$ Create a Pivot Table Using All Data in the Sales Transactions tab. Once created, please name this tab "Pivot"

$2$ While formatting the Pivot table, please complete the following:

Filters: Country

Rows: Region Name, Product Name

Values: Units Sold, Total Sales, Total Cost, Total Profit

$*$Note: Please ensure all data is accurate. All Mexican Region Names should just reflect "Mexico"

$3$ Please format the Pivot table to be in Tabular Format, with Repeat All Item Labels on

$4$ In Value Field Settings of Pivot Table, edit each field to reflect the following:

Units Sold: Number $(0$ decimal places and comma separator for $1000)$

Total Sales: Currency with $0$ decimal places

Total Costs: Currency with $0$ decimal places

Total Profit: Accounting with $0$ decimal places

$5$ Please add the following slicers to the Pivot table, placing each une to the right of the pivot table:

Country, Region Name, Product Name, Sales Channel

Slicer Formatting: $2$ Columns

Slicer Settings: Hide Items with No Data

$6$ Please add a Timeline for the Pivot Table, also placing this on the right of the Pivot Table

Please base this on Quarter and Order Date

$7$ Please toggle through the slicers and the timeline options for experience in seeing how it adjusts the Pivot Tab

$8$ Please go back to the original data and create a second pivot table

When this loads, rename the tab to "Pivot $2"$

While formatting the Pivot table, please complete the following:

Filters: Country