I am trying to create a row in my tables showing the grand total of the columns and I followed these links:



Both of these do work and I got the desired output, but when I set the table to paginate server side, the total row now only shows the total of the first page.
I've been trying to find an answer but can't seem to find it. I'm sure somebody has had this problem before but I'm just not finding it.

I would just switch back to not paginating server side but I have over a dozen tables with their own queries so there would be a huge performance hit.
Looking for any advice.