Column Grand Total using Pagination

I may be missing something, but I am unable to find a native method or a solved solution in the forums already.

We would like to have the Grand Total (sum of all data in dataset) for a column to be displayed in the footer when using pagination.

Currently Suite 7.0 has the sum function, but this applies to only the visible data on the “page”

We could create a function that updates the footer with the setColumns function, but this seems like extra processing that might already have been solved.

Your help would be appreciated.

Thank you

You may try to update the footer cell value manually.
Here is a simple example: