Hi all

I have the following issue:

I have two fact tables:

Table 1 with Production date, Order No., Qty

Table 2 with Sale date, Order No. Sale amt.

I created a Date table and related to Production date and Sale date

If I create a pivot table with date and sale amt, it takes sale amt as per sale date only.

If I want the sale amt as per Production date, it is not working.  The relationship between Date table and fact tables are active.  

Can you pls help to solve the above?

Thanks