Go the "Challenge worksheet. 1. Sort the bar chart by Sales in the Central Region. (Hint: Use a calculated field containing only Central Region Sales facilitate this.) 2. For each Item, label the percentage of total Sales applicable to each Region for each item. Include an appropriate title. Visual should look something like this: Region East Central % East+Central Sales by Item (sorted by Central Region sales) Item F Bretford CR4500 Series Slim.. 90.62% 9.38% Bretford CR8500 Series Mee.. 56.14% 43.86% Canon PC1060 Personal Las.. 65.78% 34.22% Hon Multipurpose Stacking 52 22% 47.78% Polycom Voice Station 100 95.76% GBC DocuBind 200 Manual 70.67% 29.33% Sharp AL 1530CS Digital Co. 63 55% % 36.45% Brother DCP1000 Digital 3 in.. 100.00% Global Leather and Oak Exe.. 88.09% 11.91% Fellowes PB500 Electric Pun.. 31.06% 68.94% Honeywell Enviracaire Porta.. 68,01% 31.99% SAFCO Plan Master Heigh-A 85.01% 14.99% Okidata ML 184 Turbo Dot M.. 83.03% 16.97% Chromcraft Bull-Nose Wood.. 56.28% % 43.72% Canon imageCLASS 2200 A.. 57.39% 42.61% Global High Back Leather Ti. 65.60% 34.40% Hewlett Packard LaserJet 33.. 58.04% 41.96% Canon Image Class D660 Co.. 100.00% Fellowes Super Stor/Drawer.. 100.00% Fellowes PB300 Plastic Com.. 86.54% Hewlett-Packard cp1700 [D, 35.30% 64.70% Global Troy Executive Lea 18.77% 81.23% Okidata ML 390 Turbo Dot M.. 100.00% Fellowes Staxonsteel Draw.. 44.93% % 55.07% Riverside Palais Royal Lawy.. 61.25% 38.75% Hewlett-Packard Business C.. 95.99% Hoover Wind Tunnel Plus.. 91.02% Ibico Hi-Tech Manual Bindin.. 61.39% 38.61% LX 788 85.11% Office Star - Mid Back Dual.. 49.97% 50.03% Hon Olson Stacker Stools 93.51% Hewlett-Packard Deskjet 122.. 64.71% 35.29% % Tenex Contemporary Contur.. 93.54% Sauder Facets Collection Lo.. 53.08% 46.92% Panasonic KX-P1150 Dot Ma.. 43.83% 56.17% Hon 9400 Series Round Ta SO $5,000 $10,000 $15,000 $20,000 $25,000 $30,000 $35,000 $40,000 $45,000 $50,000 $55,000 $60,000 $65.000 $70,000 $75,000 $80,000 $85,000 $90,000 $95.000 $100,000 $105.000 Sales Go the "Challenge worksheet. 1. Sort the bar chart by Sales in the Central Region. (Hint: Use a calculated field containing only Central Region Sales facilitate this.) 2. For each Item, label the percentage of total Sales applicable to each Region for each item. Include an appropriate title. Visual should look something like this: Region East Central % East+Central Sales by Item (sorted by Central Region sales) Item F Bretford CR4500 Series Slim.. 90.62% 9.38% Bretford CR8500 Series Mee.. 56.14% 43.86% Canon PC1060 Personal Las.. 65.78% 34.22% Hon Multipurpose Stacking 52 22% 47.78% Polycom Voice Station 100 95.76% GBC DocuBind 200 Manual 70.67% 29.33% Sharp AL 1530CS Digital Co. 63 55% % 36.45% Brother DCP1000 Digital 3 in.. 100.00% Global Leather and Oak Exe.. 88.09% 11.91% Fellowes PB500 Electric Pun.. 31.06% 68.94% Honeywell Enviracaire Porta.. 68,01% 31.99% SAFCO Plan Master Heigh-A 85.01% 14.99% Okidata ML 184 Turbo Dot M.. 83.03% 16.97% Chromcraft Bull-Nose Wood.. 56.28% % 43.72% Canon imageCLASS 2200 A.. 57.39% 42.61% Global High Back Leather Ti. 65.60% 34.40% Hewlett Packard LaserJet 33.. 58.04% 41.96% Canon Image Class D660 Co.. 100.00% Fellowes Super Stor/Drawer.. 100.00% Fellowes PB300 Plastic Com.. 86.54% Hewlett-Packard cp1700 [D, 35.30% 64.70% Global Troy Executive Lea 18.77% 81.23% Okidata ML 390 Turbo Dot M.. 100.00% Fellowes Staxonsteel Draw.. 44.93% % 55.07% Riverside Palais Royal Lawy.. 61.25% 38.75% Hewlett-Packard Business C.. 95.99% Hoover Wind Tunnel Plus.. 91.02% Ibico Hi-Tech Manual Bindin.. 61.39% 38.61% LX 788 85.11% Office Star - Mid Back Dual.. 49.97% 50.03% Hon Olson Stacker Stools 93.51% Hewlett-Packard Deskjet 122.. 64.71% 35.29% % Tenex Contemporary Contur.. 93.54% Sauder Facets Collection Lo.. 53.08% 46.92% Panasonic KX-P1150 Dot Ma.. 43.83% 56.17% Hon 9400 Series Round Ta SO $5,000 $10,000 $15,000 $20,000 $25,000 $30,000 $35,000 $40,000 $45,000 $50,000 $55,000 $60,000 $65.000 $70,000 $75,000 $80,000 $85,000 $90,000 $95.000 $100,000 $105.000 Sales