1 Reply Latest reply: Dec 26, 2016 2:11 PM by Liron Baram RSS

    Dates in expression search filter

    Андрей Шепель

      Colleagues, hi!

      I have one simple table with Date field and some Sales value.

      Next my script load second table only with one field Date2. This tables are not connected with each other and my task to make pivot table, which must contain Date2 dimension and sum(Value) for such logic

       

        

      Date2Expr
      01.11.2016Sales for 01.11 from Date1
      02.11.2016Sales for 01.11-02.11 form Date1
      03.11.2016Sales for 01.11-03.11 form Date1
      04.11.2016
      05.11.2016

       

      This calculation must be implement only by expr, not in load script.

      Have anybody ideas how to make it?

      Thanks.