Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ..
Perhaps you can concatenate the tables: Fact Table with Mixed Granularity