Sorry for the late response. Here is an example.
Month/Rep/Product is the key here.
The Target table X shows target for all three products for months Apr & May.
From Sales table Y, we see that rep S2 did not sell product B in May.
However , I would like to show his Target for that month & that product in the chart.
Target X:
Month, Sales_Rep, Product, Target
Apr, S1, A, 1000
Apr, S1, B, 2000
Apr, S1, C, 3000
May, S2, A, 1500
May, S2, B, 2500
May, S2, C, 2000
Sales Y:
Month, Sales_Rep, Product, Sales
Apr, S1, A, 1k
Apr, S1, B, 2k
Apr, S1, C, 3k
May, S2, A, 1.5k
May, S2, C, 2.0k
