Forum Discussion
lifer
6 years agoRegular Visitor
Issues with relationships
Hi! I have an issue with a dashboard, where i have 2 different tables with info that i need to be able to filter with 1 same filter. I made a colum with exactly the same data to identify a da...
kentyler
6 years agoSolution Sage
Can you extract the distinct buyer names into a table. Then that table should be in a 1 to many relationship with both table 1 and table 2
lifer
6 years agoRegular Visitor
Unfortunately no, i cannot, because there is no buyer name on one table, so there is no way to create a relation with that data.
I have tryied to remove the buyer name and buyer code, so i will have almost the same columns, but still not working, im only able to filter 1 table with the date or the region at the same time.