14 Replies Latest reply: Jan 12, 2018 3:58 AM by Sunny Talwar RSS

    Variable value change according to dimension in set analysis

    paridhi mantri

      Hi,

       

      I have Date, Membership signup date ,Customers and orders, I want the output where each customer before signup how many orders or after signup how much orders they are placed.

       

      Each customer have their each signupdate.

       

      For example-

         

      CustDateSignUp dateorders
      12017-12-302017-10-300.49145
      12017-12-122017-10-300.98633
      12017-11-192017-10-300.32968
      12017-11-162017-10-300.24649
      12017-11-062017-10-300.19674
      12017-11-062017-10-300.19695
      12017-11-062017-10-300.19768
      12017-11-062017-10-300.19798
      12017-10-302017-10-300.33333
      12017-10-072017-10-300.5
      12017-03-252017-10-301
      12017-02-232017-10-300




      I want output sum(orders) before signup date  2017-10-30 and after signupdate, I have so many customers and having different signup date.


      Thanks for help!