Total with Accumulation

[#1]

Hi Forum

I have a Straigth Table. I have to show the total (last row). This is the Amount (30 and 17). What can i Do ?

Cod Val Type Amount Amount 2

1 10 Ing 10 0

2 20 Ing 30 0

3 5 Egr 0 5

4 5 Egr 0 10

5 7 Egr 0 17

TOTAL 30 17

I appreciate very much your suggestions .

[#2]

Do you mean the totals should be 40 and 32?

If so, you can use the attached sample.

If not, you might want to look at the AGGR() statement.

[#3]

Hi Mark

Thanks a lot for your reply !!

I use Agrr() Statement. Max(aggr(Amount2 , Cod , Type)). The total is OK.