How to get total specific columns of a table page wise

Summary:

Content (please ensure you mask any confidential information):

Hello everyone,

I have a requirement where I need to get total of two columns namely cr amount and dr amount in a table in vbcs which is created using ADP connection using an ORDS connection.I have already taken the whole total of those columns using two rest APIs.Now my requirement is to get the total of those columns for page wise,as I have included the pagination control on the table splitting the dataset to different pages

Can someone help me with this requirement on how to implement this one.