eexcel

N O P Q R S T A B D E F G H 1 J KL M 1 Create the following Pivot tables using the data provided on the Data sheet. Place the table right below the corresponding images provided 2 Customer totals by country Sales channel totals by country 3 Row Labels Sum of Total Sum of Total Column Labels 4 Canada 286.02 Row Labels Online Retail Grand Total 5 Philip Dean 286.02 Canada 233.52 52.5 286.02 6 France 52.7 France 20.3 32.4 52.7 7 Kathy Schmidt 52.7 Spain 157.5 5 162.5 8 Spain 162.5 United Kingdom 27.86 5.4 33.26 9 George Hill 162.5 United States 290.85 238.49 529.34 10 United Kingdom 33.26 Grand Total 730.03 333.79 1063.82 11 Craig Hicks 33.26 12 B United States 529.34 13 Arthur James 30.04 14 Jessica Miller 128.14 15 Mary Green 371.16 16 Grand Total 1063.82 17 18 19 20 21 22 Quantity of Chair, Desk, Lamp sold online Sum of Quantity Column Labels - Row Labels Chair Desk Lamp Grand Total Arthur James 1 1 Craig Hicks 1 1 George Hill 3 1 4 Jessica Miller 2 2 4 Kathy Schmidt 1 1 Mary Green 1 1 2 Philip Dean 2 2 Grand Total 5 3 7 15