sum up rows in last row
gtriantFeb 15 2007 — edited Feb 15 2007HI!
Is there a way that i can have a last row in my generated table, that sums up all the above rows???
For instance:
I have a table like the following
Employee|Salary
Jim | 2000
John | 1500
Maria | 2000
Total | 5500
How can i generate the total???
And how is it possible to use any word for the rows that can't be summed (Strings)?
If it cannot be done, can i take the totals with a second query and join them to the main table???