What I want is the sum(TARGET) for the Period selection. If the revenue table doesn’t have all the periods and the selection is a whole year, then the sum (TARGET) must be shown for the whole year. When the selection is of some periods then the target must show the sum over these periods.
My table link key is not good (I think), but when I keep more then one column the same name then I have synthetic tables.
When the revenue table doesn’t have records for a sales person in period 6 and the target table has, then the target must be shown for period 6. This off course when QUARTER = 2. I think the table links must be altered to accomplish this, but I don't know how.