Start Building Professional
Web Apps Today

Pivot Table Total Row

We're trying to use the pivot table in the grid and we were wondering if there was a way to have a row total the values at the bottom similar to Microsoft ExCel? Is there not a mechanism to do this or is there something we're missing?

Current version of pivot doesn't support such built-in functionality. 
Pivot tabel is normal grid instance, so it possible to add footer to it through existing grid'a API, and place some kind of total in it. 

mygrid._pgrid.attachFooter('1,#stat_total');
mygrid._pgrid.setSizes();
mygrid._pgrid.callEvent('onGridReconstructed',[])

Currently we are working on extending the pivot functionality, so if you have some ideas about useful improvments - please drop email to the support@dhtmlx.com