insert targets (excel) by date

[#1]

Hello guys,

I want to insert a target table for salesperson by date and link that with the master calendar

How can I realize that ?

I Have all of my data in one table:

ALL:

DocNo,

Date,

Salesperson,

Amount,

...

ExcelTarget:

Salesperson & '|' & Date as %KEY_TARGET

Salesperson,

Date (2012 - 2015, fictitious dates per Month and year once ..)

TargetMonthAmount, TargetMonthAmount*12 as TargetYearAmount  ( OR TargetYearAmount, TargetYearAmount/12 as TargetMonthAmount)..no relevant which way.

My problem is, I can't join / combine the 2 Date table, even with Join ..

[Gysbert_Wassenaar]

Perhaps you can concatenate the tables: Fact Table with Mixed Granularity