Adding one summary row at the bottom

[EinarRoed]

This seems like an absurdly newbie question, but I've almost only worked in EG & DIS and avoided user written code.

Consider this very basic example code:

http://pastebin.com/AD5yKuA2

I want to add a single row at the bottom, which should simply display the sum of the 'amount' column. It should look like this:

deal_no	cust_no	kid	amount
65465165	56165165	9198191919616161511162	10
65498153	51651666	5191989847987654646565	25
46519899	18548949	5161989897686165165161	5
19884958	56165199	6123165486351657678999	15
			55

Can someone please tell me how to add the final line? I figured I might simply use output belop=sum(belop), but that doesn't seem to work.

[LinusH · Accepted solution]

Adding sums is not really a table thing, rather a report requirement.

PROC PRINT could do this.