As sales manager for ABC Office Supply, I need to have a data set of sale transactions analyzed.Each transaction contains the; Date, Region, Rep, Item, Units, Unit Cost, and Total.Initially I only need the total dollar for each sales person and the total dollar amount for each item.Below is the data from accounting.

Project 10 As sales manager for ABC Office Supply, I need to have a data set of sale transactions analyzed. Each transaction contains the; Date, Region, Rep, Item, Units, Unit Cost, and Total. Initially I only need the total dollar for each sales person and the total dollar amount for each item. Below is the data from accounting. Date Region Rep Item Units Unit Cost Total 1/6/2005 Quebec Jones Pencil 95 1.99 189.05 1/23/2005 Ontario Kivell Binder 50 19.99 999.50 2/9/2005 Ontario Jardine Pencil 36 4.99 179.64 2/26/2005 Ontario Gill Pen 27 19.99 539.73 3/15/2005 Alberta Sorvino Pencil 56 2.99 167.44 4/1/2005 Quebec Jones Binder 60 4.99 299.40 4/18/2005 Ontario Andrews Pencil 75 1.99 149.25 5/5/2005 Ontario Jardine Pencil 90 4.99 449.10 5/22/2005 Alberta Thompson Pencil 32 1.99 63.68 6/8/2005 Quebec Jones Binder 60 8.99 539.40 6/25/2005 Ontario Morgan Pencil 90 4.99 449.10 7/12/2005 Quebec Howard Binder 29 1.99 57.71 7/29/2005 Quebec Parent Binder 81 19.99 1619.19 8/15/2005 Quebec Jones Pencil 35 4.99 174.65 9/1/2005 Ontario Smith Desk 2 125 250.00 9/18/2005 Quebec Jones Pen Set 16 15.99 255.84 10/5/2005 Ontario Morgan Binder 28 8.99 251.72 10/22/2005 Quebec Jones Pen 64 8.99 575.36 11/8/2005 Quebec Parent Pen 15 19.99 299.85 11/25/2005 Ontario Kivell Pen Set 96 4.99 479.04