Calculation based on rows

[Saurabh_K14999]

Hi All,

I have a table 

ID,SALE,AMOUNT

1,5,50

2,4,100

In this table i want to show calculation based on 1st and 2nd row in the 3rd row as 3.

Eg

ID,SALE,AMOUNT

1,5,50

2,4,100

3,9,150

I want to show addition of 1st and 2nd row in the third row with id as 3.

Regards,

SK

[Or]

Not sure how well this will apply to whatever it is you're trying to do, but at least for this case,

Table1:

Load ID, Sale, Amount From SomeTable;

Concatenate

Load Sum(ID) as ID, Sum(Sale) as Sale, Sum(Amount) as Amount

Resident Table1;