php - Display SUM of each Column , jqGRID -
I am using jqGrid and displaying my data in the grid. I have 5 columns. I want to calculate the SAM and at the end of the column, probably want to display the amount in the footer !! [In the image below, TOTAL is displayed for the amount only, I want to display it for all the columns at the end of the column
You can get it, LoadComplete - function in the Total column in the footer of the grid , you should enable footer and you should use the loadComplete function as below, < Pre> For more information regrading loadComplete function, take a look. footroot : Correct, load full: function () {var sumOfPrice = jQuery ("# gridId"). JqGrid ('getCol', 'zodiac', false, 'yoga'); JQuery ("#GridID") JqGrid ('Footwriting Data', 'Set', {Date: 'Total:', Amount: sumOfPrice}); }
Comments
Post a Comment