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 slicer (Synchronized through report pages) it shows the correct information, but when I try to see the sales information, it shows as if all sales happened on launch date.
Already tried merging tables or using USERELATION without success.
Support needed: I need to filter by "Fiscal Month Number" and see inventory based on "ICW" but sales on "Service Month"could it be done? Ideally I would like to keep synchronized slicer for date across report pages.
Report goal:
1- Inventory of product at launch date ("ICW" column)
2- Sales over the next 3M after launch ("Service Month" column)
Data structure:
- Fiscal Calendar table --> Launch Information by product (Relation ship on Date | Launch Date (ICW)
- Launch Information by product --> Sales (Relation on Product (IRC) | Product (IRC)
Thank you very much in advance for your help.
4 Replies
- mussaendaCommunity Champion
- JoseAGonzalezNew Member
Hi mussaenda,
This would create a circular relationship, and by default I can only have one relationship active. This is why I tried USERELATIONSHIP (to select the new Date relationship) but without sucess.
- mussaendaCommunity Champion
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.