Hi.
many peoples asked for unsorted table footer or TOTAL row.
I wrote this function and hope to help you.
----------------------------------------------
step 1 ) declare this variable at top of your script
footer=[['1st column text',1st_ColSpan],['2nd column text',
2nd_ColSpan],....];
example
footer=[['Total',5],['1,234,567',1]]; // <---assume our table have 6
columss
step 2 ) add this function to your script (anywhere)
function addFooter(){
if (document.getElementById('google-visualization-table-
footer')) return
var tables=document.getElementsByTagName('TABLE');
for (i=0; i<tables.length; i++)
if (tables[i].className=='google-visualization-table-
table'){
var r=tables[i].insertRow();
r.id='google-visualization-table-footer'
var c;
r.className='google-visualization-table-tr-head';
for (j=0; j<footer.length; j++){
c=r.insertCell();
c.className='google-visualization-table-th'
c.innerHTML=footer[j][0]
c.colSpan=footer[j][1]
}
}
}
step 3 ) add these event listener before table.draw() method
google.visualization.events.addListener(table, 'ready',
addFooter);
google.visualization.events.addListener(table, 'sort',
addFooter);
google.visualization.events.addListener(table, 'page',
addFooter);
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.
