Forum Discussion
dr_anas
2 years agoFrequent Visitor
Building relations
I need your assistance to fix the relationship between the two tables in the screenshot. I need to establish a relationship with the bonus table, and I have a fact sales table, but it is arriving ma...
Idrissshatila
2 years agoSuper User
hello dr_anas ,
in order to help you, we need to understand the logic about the relation between the fact sales and the bonus table.
- dr_anas2 years agoFrequent Visitor
The logic goes like this: the number of bonuses quantities for each item over the date has to be computed. Each item has a bonus with zero value quantities sold throughout the year.
I wish it is clear now If not, please let me know so that I can clarify more.