var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Sub and grandtotals?
Got a table A in postgresql
site item cost
zzz aaaa 20
aaa bbbb 30
rrrr cccc 10
There are a lot of site linked to different items.
The cost column is displayed in query.
I want a grandtotal at the end displaying the totalcost of all the items in query.
Thanks in advance.
Hope this works
Maybe you can run another query at the end of the previous query like
select sum(cost) as grand_total from A;
Another method which i think is possible is little more complex i.e.
you can look more for create aggregate at
I want to display only specific items which are allocated between this table and a next so my grand total query would have to be included in first query.
So I'll have to go with the create aggregate option
Thanks for reply