To understand the value of orders customers place,

show R Code to calculate the aggregate annual sales for each customer?

Acme Inc Sales.xls

Observations: 9,994 Variables: 21 $ `Row ID` 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23,... $ `Order ID` "CA-2017-152156", "CA-2017-152156", "CA-2017-138688", "US-2016-108966", "US-2016-1... $ `Order Date` 2017-11-08, 2017-11-08, 2017-06-12, 2016-10-11, 2016-10-11, 2015-06-09, 2015-06-0... $ `Ship Date` 2017-11-11, 2017-11-11, 2017-06-16, 2016-10-18, 2016-10-18, 2015-06-14, 2015-06-1... $ `Ship Mode` "Second Class", "Second Class", "Second Class", "Standard Class", "Standard Class"... $ `Customer ID` "CG-12520", "CG-12520", "DV-13045", "SO-20335", "SO-20335", "BH-11710", "BH-11710"... $ `Customer Name` "Claire Gute", "Claire Gute", "Darrin Van Huff", "Sean O'Donnell", "Sean O'Donnell... $ Segment "Consumer", "Consumer", "Corporate", "Consumer", "Consumer", "Consumer", "Consumer... $ Country "United States", "United States", "United States", "United States", "United States... $ City "Henderson", "Henderson", "Los Angeles", "Fort Lauderdale", "Fort Lauderdale", "Lo... $ State "Kentucky", "Kentucky", "California", "Florida", "Florida", "California", "Califor... $ `Postal Code` 42420, 42420, 90036, 33311, 33311, 90032, 90032, 90032, 90032, 90032, 90032, 90032... $ Region "South", "South", "West", "South", "South", "West", "West", "West", "West", "West"... $ `Product ID` "FUR-BO-10001798", "FUR-CH-10000454", "OFF-LA-10000240", "FUR-TA-10000577", "OFF-S... $ Category "Furniture", "Furniture", "Office Supplies", "Furniture", "Office Supplies", "Furn... $ `Sub-Category` "Bookcases", "Chairs", "Labels", "Tables", "Storage", "Furnishings", "Art", "Phone... $ `Product Name` "Bush Somerset Collection Bookcase", "Hon Deluxe Fabric Upholstered Stacking Chair... $ Sales 261.9600, 731.9400, 14.6200, 957.5775, 22.3680, 48.8600, 7.2800, 907.1520, 18.5040... $ Quantity 2, 3, 2, 5, 2, 7, 4, 6, 3, 5, 9, 4, 3, 3, 5, 3, 6, 2, 2, 3, 4, 7, 7, 2, 3, 2, 3, 7... $ Discount 0.00, 0.00, 0.00, 0.45, 0.20, 0.00, 0.00, 0.20, 0.20, 0.00, 0.20, 0.20, 0.20, 0.20... $ Profit 41.9136, 219.5820, 6.8714, -383.0310, 2.5164, 14.1694, 1.9656, 90.7152, 5.7825, 34...