5 Replies Latest reply: Apr 26, 2017 5:05 AM by Sebastian Fagerlund RSS

    Problem with calendar?

    Sebastian Fagerlund

      Hi

      I have the following problem:

       

      Example: i have 3 tabels, two from the database and one mastercalender.

      I want to to compare Salesamount and Orderamount in a diagram. But I miss I few Orderamount if i haven't sold the product the same day as the order.

      How do i solve this?

       

      Sales:

      ProductID,

      Date,

      SalesAmount,

      ProductID&'-'&Date as SalesOrderKey

       

      Order:

      //ProductID,

      //Date,

      OrderAmount,

      ProductID&'-'&Date as SalesOrderKey

       

      Calendar:

      ...

      Date

      Week

      Year