Something like this.
"Year_Month" ("yyyymm") and Customer Name as relationships.
Then put Prod A purchase from primary Data base (Blue) and Prod B purchase from secondary datasource (Orange)
Prod_A_B.twbx 37.1 KB
thanks. How do I filter the date the last 3 month from a specific date.
In the relative date filter dialog box there is an option to Anchor relative to a date.