Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks!
There are two different tables, Table: Target and Table: Achieved
There are two different Dates, one in each Table: Target_Date and Achieved_Date
The two tables are connected via: Customer
There is one diagram which Shows us the Achieved against the Target (i.e. Sales)
I have to select both Dates (Period Month, i.e. August) as I have no Master Calendar.
Doing this, everything selected Shows up, but.....
Targets without Achievements in the selected period do not Show up because the selected
Achieved_Date does not give any results (no Achievements in this period), leading in suppressing the
data of the Target Table, although selected via the Achieved_Date.
So: What is the way to go that the Targets Show up although they have no Achievements so far in the
selected Period?
Seems to be difficult to explain, however, I just tried to do my best,
and thank you in advance for for efforts.
If questions left, please contact me,
Wolfgang
Can you provide some dummy data?