How to add sum of values of the columns in a grid

Question

Hi, I could not find any docs satisfying my requirement .Can anyone help me in designing a grid as below.

Name 
 textbox1 
 textbox2 
 textbox3

PersonA 
 10 
 1 
 100

PersonB 
 20 
 2 
 100

TOTAL 
 30 
 3 
 200

User will enter values in rows for textbox1, textbox2 and textbox3. Last row should display the total of the values entered in above rows.

Mike Schmitt · Answer

This should be doable. Generally speaking this is a use case where you should be querying the data in advance into a local variable, then using that to populate the grid. 
 What have you tried already? Are you having any specific difficulties?

Mike Schmitt · Answer

Niharika said: i have an interface where there are multiple filters, when user applies filters lets suppose it applies on two fields, then what ever rows are returned in non -editable grid, then i have to show the sum of one column 
 Yes, I understand, since that's pretty much what you already said before. 
 My same 2 questions still apply: what have you tried already, and what specific difficulties are you having (if any)?

Mike Schmitt · Answer

No, that won't be possible. You will need to use the "classic" pattern wherein you first query the data for the current page of the grid into a local variable (as a datasubset), then populate the grid using that. In this way you'd be able to manipulate the result of your query to always append a "final" row of data that contains the calculation based on the sum of the queried (filtered/etc) rows.

How to add sum of values of the columns in a grid

Top Replies