Getting sum of values from grid column with pagination.
In my app, I have used datasource type as XPath as I want to show sum of the values in column at the bottom of the grid. This sum is being shown for all the fetched records. i.e. if i am having 50 records in db and I have set the page size as 10 , sum is shown for whole 50 records. How can I configure this so that I will get the sum for only those records which are being displayed on grid at that time ?
There is no standard option to achieve this AFAIK.
You’ll need to implement the custom logic and functions for this.