Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3. Who are the most valuable customers? Please create ONE PivotTable showing the Customer Names (Row) and the total Order Quantity (Columnl), Total Sales (Column2),
3. Who are the most valuable customers? Please create ONE PivotTable showing the Customer Names (Row) and the total Order Quantity (Columnl), Total Sales (Column2), and Total Prot (Column3). Sort in descending order of Order Quantity and show Customer Name of Top 5 Order Quantity using Filter in the PivotTable. (worksheet3) Produc Order Date Order Prior Order Quant Sales Discou Ship Moc Profit Unit Pri Shipping Co |Customer Nan Province Region Customer Segme Order 213.25 38.94 35 Muhammed Macintyre Nunavut Nunavut Small Business Office Su 2 3 10/13/10 Low 6 261.54 0.04 Regular Air Consumer Office Su 293 10/1/12 High 49 10123.02 0.07 Delivery Truck 457.81 208. 16 68.02 Barry French Nunavut Nunavut 27 244.57 0.01 Regular Air 46.71 8.69 2.99 Barry French Nunavut Nunavut Consumer Office Su 293 10/1/12 High 483 7/10/11 High 30 4965.7595 0.08 Regular Air 1198.97 195.99 3.99 Clay Rozendal Nunavut Nunavut Corporate Technolog 8/28/10 Not Specified 19 394.27 0.08 Regular Air 30.94 21.78 5.94 Carlos Soltero Nunavut Nunavut Consumer Office Su 515 3/28/10 Not Specified 21 146.69 0.05 Regular Air 5.64 4.95 Carlos Soltero Nunavut Nunavut Consumer Furniture 515 613 6/17/11 High 12 93.54 0.03 Regular Air 54.04 7.3 7.72 Carl Jackson Nunavut Nunavut Corporate Office Su 22 905.08 0.09 Regular Air 127.70 42.76 6.22 Carl Jackson Nunavut Nunavut Corporate Office Su 613 6/17/11 High 35 Monica Federle Nunavut Nunavut Corporate Office Su 10 3 643 3/24/11 High 21 2781.82 0.07 Express Air -695.26 138.14 11 7 678 2/26/10 Low 44 228.41 0.07 Regular Air -226.36 1.98 8.33 Dorothy Badders Nunavut Nunavut Home Office Office Su Nunavut Home Office Office Su 12 7 807 11/23/10 Medium 45 196.85 0.01 Regular Air 166.85 4.28 6.18 Neola Schneider Nunavut 13 3 807 11/23/10 Medium 32 124.56 0.04 Regular Air -14.33 3.95 2 Neola Schneider Nunavut Nunavut Home Office Office Su 14 1 868 6/8/12 Not Specified 32 716.84 0 Regular Air 134.72 21.78 5.94 Carlos Daly Nunavut Nunavut Home Office Office Su 15 868 6/8/12 Not Specified 31 1474.33 0.04 Regular Air 1 14.46 47.98 3.61 Carlos Daly Nunavut Nunavut Home Office Technolog 16 933 8/4/12 Not Specified 15 80.61 0.02 Regular Air 4.72 5.28 2.99 Claudia Miner Nunavut Nunavut Small Business Office Su 17 0 995 5/30/11 Medium 46 1815.49 0.03 Regular Air 782.91 39.89 3.04 _Neola Schneider Nunavut Nunavut Home Office Furniture 18 1 998 1 1/25/09 Not Specified 16 248.26 0.07 Regular Air 93.80 15.74 1.39 Allen Rosenblatt Nunavut Nunavut Small Business Office Su 4462.23 0.04 Delivery Truck Home Office 2/14/12 Critical 44 440.72 100.98 26.22 Sylvia Foulston Nunavut Nunavut Furniture 19 5 1 154 11 663.784 0.25 Regular Air 481.04 71.37 69 Sylvia Foulston Nunavut Nunavut Home Office Furniture 20 5 1 154 2/14/12 Critical 21 3 1344 4/15/12 Low 15 834.904 0.06 Regular Air -11.68 65.99 5.26 Jim Radford Nunavut Nunavut Corporate Technolog 22 4 1344 4/15/12 Low 18 2480.9205 0.01 Regular Air 313.58 155.99 8.99 Jim Radford Nunavut Nunavut Corporate Technolog Nunavut Nunavut Consumer Office Su 23 3 1412 3/12/10 Not Specified 13 59.03 0.1 Express Air 26.92 3.69 0.5 Carlos Soltero 24 4 1412 3/12/10 Not Specified 21 97.48 0.05 Regular Air -5.77 4.71 0.7 Carlos Soltero Nunavut Nunavut Consumer Office Su 25 1539 3/9/11 Low 33 511.83 0.1 Regular Air -172.88 15.90 13.18 Carl Ludwig Nunavut Nunavut Corporate Office Su 26 0 1539 3/9/11 Low 38 184.99 0.05 Regular Air -144.55 4.89 4.93 Carl Ludwig Nunavut Nunavut Corporate Technolog 27 1 1540 8/4/12 High 30 80.9 0.09 Regular Air 5.76 2.88 0.7 Don Miller Nunavut Nunavut Home Office Office Su 23 67.24 0.06 Regular Air 4.90 2.84 0.93 Annie Cyprus Nunavut Nunavut Home Office Office Su 28 1702 5/6/11 High 25 12028.23 0.01 Delivery Truck -547.61 449.99 49 Carl Ludwig Nunavut Nunavut Corporate Technolog 29 1761 12/23/10 High Sales Sheet1 +
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started