2 Replies Latest reply on May 9, 2012 10:27 AM by Forrest Adam

    How do I get two different Fact table dates to show up under their respective date columns?

    Forrest Adam

      I have a Fact_Adjustment table that indicates when an item's quantity on hand was adjusted and I have a Fact_Orders table that indicates when an order was placed and decremented inventory.  I want to show the summed values of adjustments AND orders that occurred within a specified period of time.  It appears that if I use the Fact_Adjustment date in the columns the Fact_Orders transactions just show up under that date range and not their own. 

       

      Once this is resolved I would like to use the combined date to also filter the results of both Fact tables.

       

      Any suggestions are appreciated?