Forum Discussion
Getting two different date with one relationship
Hi everyone, Issue: I have a report to present inventory at launch date (ICW) and sales over the next three months (Service Months). When I see the inventory and filter with Fiscal Year/Month sli...
hi JoseAGonzalez,
I understand that.
And I assumed that you will remove the relationship between the two fact tables and relate them both to the date.
Hi mussaenda ,
I have basic information of the products on the inventory table and also particular inventory data I need when reflecting sales. By having the conection through Date I lose this relationship and results showed are not accurate.
I would try to reshape data and have 4 tables to see how it hows in the mean time.