gistfile1.js

                	var data = response.getDataTable();
                	
                	// coz google does not support 'total', so we calculate it here make it show different
                	var total = 0;
                	for ( var i = 0; i < data.getNumberOfRows(); i++ ) {
                	  total = total + data.getValue(i, 1);
                	}
                	
                	data.addRow([
                		{v: 'Grand Total', p: {style: 'font-weight: bold;'} }, 
                		{v: total,  p: {style: 'font-weight: bold;'}} 
                    ]);