How to show even non matched data for particular date selection

[vinayvishwanath]

Hi All,

I have 2 tables in my data model as Actuals Table (AT) and Target table (TT). AT has data only upto Jun 2020 and TT has data for the entire 2020 year. To achieve the granularity i have used a Key with the combination as Brand&'-'&Type&'-'&Region&'-'&Year&'-'&Month to map the 2 tables. I have used Date filter coming from AT.

Issue: When i am using the Date filter from AT then all the records from AT and corresponding matched records in TT are visible in the charts, but there are some records in TT which are not having a match with AT and i wanted to show these records as well. Kindly request to suggest or advise on how to show non matched records from TT as well.

Thank you in Advance.

[martinpohl]

so you have to create a link table

Keyfield

Brand&'-'&Type&'-'&Region&'-'&Year&'-'&Month

and also each single field from Keyfield so you can select each value.

The better way is to concatenate AT and TT into one table.

Regards