Using LINQ to get roll-up data

                        var groups = from SPListItem item in licMktDocs
                                     orderby item["Modified"] descending
                                     group item by item["Title"] into itemgroup
                                     select new { Title = itemgroup.Key, Completion = itemgroup.Count(i => i["Completion"] == "completed") / itemgroup.Count() * 100, Date = itemgroup.First()["Date"]};