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

Following the patterns here

https://docs.appian.com/suite/help/21.3/Editable_Grid_Component.html#examples

You simply add a last row showing the required components and values.

My requirement is i have to do sum of values returned when user applies filter in non -editable grid. For example, grid has mileage column, when user applies filter then if  rows are returned then i have to display sum of mileage returned from three rows.

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?

So the requirement is 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 values in some field

I was thinking of storing the value returned from a!gridField into some var  (means whatever value is being returned when user applies xyz filter would be displaying in that grid and the data stored in grid can help me acheive the same, but i didnt find any parameter in a!gridField through which i can do this.

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)?

I am thinking to use that data populated in grid and then doing that calculation but what you are saying is opposite

I am thinking to use that data populated in grid and then doing that calculation but what you are saying is opposite