Forum Discussion

JoseAGonzalez's avatar
JoseAGonzalez
New Member
2 years ago

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

    • JoseAGonzalez's avatar
      JoseAGonzalez
      New 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.

      • mussaenda's avatar
        mussaenda
        Community 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.