Problem with calculated dimension

    Hello,

     

    I've got a problem. I' ve got 2 tables.

    In first I,ve got data about sales:  value of sales, customer, product  and invoce date.

    In second I've got data about promotions, that is: customer, product,  start date of promotion and end date of promotions.

    I've connected this table by key: customer_product

    And now I want to create a table (straight or pivot) in which i could count amount of sale between start and end date of promotions.

    I've tried do this in expressions, and in calculated dimesnions but it doesn't work proprely.

     

    Maby someone has solved such problem.

     

    Regards

    christobar