We are using virtual scrolling in our grid. And the Grid allows InCell editing to users. Now when user updates the value in a cell, we immediately want to display the Total in the footer. We cannot refetch all the data for the page for each user edit.
The client side data has only as many rows as the pagesize() - so calculating client side total is not accurate.
We can calculate the total on the server side but we need some function that only gets the Aggregates in the result and updates the footer portion - we cannot afford refetch the whole page data.
Please tell us what are our options.