> In the grid, I'd like to add one rows
> at the very end.
> E.g. select sum(val1), sum(val2) from table;
>
> Any ideas?

Use a separate grid which you make 1 row in height.

Cheers,
Tobias