Team,
We have a requirement where we need to show difference of two rows in third row in paging grid. Like below , any suggestion?
Third column should show difference of row 2 minus 1st row of Column A.
Discussion posts and replies are publicly visible
What is the source of your data? Is it something static, or something with a variable number of rows? Whether this functionality is even possible at all, depends very strongly on these details which you haven't provided.
source of data is data subset and it will not change,
DataSubset is not the "source", but just how you have the local data stored. "Source" means where the data is originally coming from (unless it's just hardcoded static values in a local variable, in which case you should clarify).
This example form includes your use case
yes, though if it matters, this example is an editable grid (where the calculations are easy to do on a row-by-row and column-by-column basis), not a paging / read-only grid, where if we're going to do a similar thing, we need to assemble all the data up-front (or some other workaround).
True, but this depends on the number of rows needed. For two + 1 rows, that approach should be fine.
agreed - hence why my initial response was asking about the original source of the data, since that has a tremendous impact on what approach is taken here (or what would even work at all).
Source of data will be from database. 2 rows only per array. Second minus one...third row