Datatables grouping with aggregates

by Andrea Ci

HTML

<script src="https://cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js"></script>
<link rel="stylesheet" href="https://cdn.datatables.net/1.10.16/css/jquery.dataTables.min.css">
<table id="example" class="display" width="100%"></table>

CSS

.group{
  font-weight:bold;
  color:white;
  
}
.group td{
  
  background:green;
  
}

JavaScript

var dataSet = [
    { "name": "Tiger Nixon",			"role": "System Architect",		"city": "Edinburgh",		"days": 5421,	"birth": "2011/04/25",	"salary": 320.800 },
    { "name": "Garrett Winters",		"role": "System Architect",		"city": "Tokyo",			"days": 8422,	"birth": "2011/07/25",	"salary": 170.750 },
    { "name": "Ashton Cox",				"role": "System Architect",		"city": "San Francisco",	"days": 1562,	"birth": "2009/01/12",	"salary": 86.000  },
    { "name": "Cedric Kelly",			"role": "Senior Javascript",	"city": "Edinburgh",		"days": 6224,	"birth": "2012/03/29",	"salary": 433.060 },
    { "name": "Airi Satou",				"role": "Senior Javascript",	"city": "Tokyo",			"days": 5407,	"birth": "2008/11/28",	"salary": 162.700 },
    { "name": "Brielle Williamson",		"role": "System Architect",		"city": "New York",			"days": 4804,	"birth": "2012/12/02",	"salary": 372.000 },
    { "name": "Herrod Chandler",		"role": "Senior Javascript",	"city": "San Francisco",	"days": 9608,	"birth": "2012/08/06",	"salary": 137.500 },
    { "name": "Rhona Davidson",			"role": "Developer",			"city": "Tokyo",			"days": 6200,	"birth": "2010/10/14",	"salary": 327.900 },
    { "name": "Colleen Hurst",			"role": "Javascript Developer",	"city": "San Francisco",	"days": 2360,	"birth": "2009/09/15",	"salary": 205.500 },
    { "name": "Sonya Frost",			"role": "Software Engineer",	"city": "Edinburgh",		"days": 1667,	"birth": "2008/12/13",	"salary": 103.600 },
    { "name": "Jena Gaines",			"role": "Software Engineer",	"city": "London",			"days": 3814,	"birth": "2008/12/19",	"salary": 90.560  },
    { "name": "Quinn Flynn",			"role": "Software Engineer",	"city": "Edinburgh",		"days": 9497,	"birth": "2013/03/03",	"salary": 342.000 },
    { "name": "Charde Marshall",		"role": "Regional Director",	"city": "San Francisco",	"days": 6741,	"birth": "2008/10/16",	"salary": 470.600 },
    { "name": "Haley Kennedy",			"role": "Senior Marketing",		"city": "London",			"days": 3597,	"birth": "2012/12/18",	"salary": 313.500 },
  ...