L B D E F H I J K 1 Pivot Table 2 3 The following is the data for your Pivot Table 4 Your Final Pivot Table should include a Grand Total column and should be ordered first by region, then product, then type. An example is provided below. 5 6 Year Region Product Type Sales Sum of Sales Column Labels 7 2020 North Widget Retail $ 123.00 Row Labels 2020 2021 Grand Total 8 2020 North Widget Wholesale $ 456.00 9 2020 North Gizmo Retail $ 789.00 North $ 1,689 $ 2,925 $ 4,614 10 2020 North Gizmo Wholesale $ 321.00 - Gizmo 1,110 $ $ 1,593 $ 2,703 11 2020 South Widget Retail $ 654.00 Retail $ 789 $ 852 $ 1,641 12 2020 South Widget Wholesale $ 987.00 Wholesale $ 321 $ 741 $ 1,062 13 2020 South Gizmo Retail $ 147.00 - Widget $ 579 $ 1,332 $ 1,911 14 2020 South Gizmo Wholesale $ 258.00 Retail $ 123 $ 369 $ 492 15 2021 North Widget Retail $ 369.00 Wholesale $ 456 $ 963 $ 1,419 16 2021 North Widget Wholesale $ 963.00 South $ 2,046 $ 2,220 $ 4,266 17 2021 North Gizmo Retail $ 852.00 Gizmo $ 405 $ 1,110 $ 1,515 18 2021 North Gizmo Wholesale $ 741.00 Retail $ 147 $ 357 $ 504 19 2021 South Widget Retail $ 159.00 Wholesale $ 258 $ 753 $ 1,011 20 2021 South Widget Wholesale $ 951.00 - Widget $ 1,641 $ 1,110 $ 2,751 21 2021 South Gizmo Retail $ 357.00 Retail $ 654 $ 159 $ 813 22 2021 South Gizmo Wholesale $ 753.00 Wholesale $ 987 $ 951 $ 1,938 23 Grand Total $ 3,735 $ 5,145 $ 24 8,880 25 26 27 28 Please analyze the data in this table. What does the data mean? For example, which region is selling more? How have sales changed from one year to the next? 29 30 31 32 33 34 25 Read Me First Copy and Chart Conditional Formatting Functions Whatif Pivot Table PivotChart Macro VLOOKUP IF Charts Imp