show data suppressed by selection

[Anonymous]

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

[MK_QSL]

Can you provide some dummy data?