Calculated Field (Table)

[#1]

Hi together,

I have the following issue:

I have two concatenated tables

Type ID Date Ammount

1 001 01/10/2010 102

1 001 10/10/2010 56

1 002 02/10/2010 85

2 001 05/10/2010 100

2 002 03/10/2010 200

1 001 01/09/2010 55

.........

So I want to create new table with the same structure and Ammount=sum(ammount) where Type=2 - sum(ammount) where Type=1 for every month

[#2]

Hi,

can you upload a Example?