14 Replies Latest reply: Apr 27, 2018 12:52 PM by Bruno Martins-Lêdo RSS

    SET Analysis with Last Year

    Bruno Martins-Lêdo

      Hello,

       

      I have a expression with SET Analysis which I am not succeed to create.

       

      My need is to have the Amount of sales of Real Customer (FICTIF_FLAG=0) who have buy last year minimum 2 type of products.

       

      My Expression is here :

       

      SUM(

      {<

      $(v_SET_Flag_FICTIF),$(v_SET_Y-1)

      ,[KEY_CUSTOMER]={'=count({<[FICTIF_FLAG]={0},[DATE]={'<=$(=Date(Addmonths(Max(DATE),-12),'DD/MM/YYYY')) >=$(=Date(Addmonths(Min(DATE),-12),'DD/MM/YYYY'))'},[DATE.autoCalendar.Date],[DATE.autoCalendar.Month],[DATE.autoCalendar.Quarter],[DATE.autoCalendar.Week],[DATE.autoCalendar.YearMonth],[DATE.autoCalendar.Year],[PRODUCT.AXIS]={'Make-up','Fragrances','Skincare'}>} distinct [PRODUCT.AXIS])>1'}

      >} VALID_SALES/YTD_CHANGE_RATE)

       

      Do you have an idea where is my fault ?

       

      Kind regard,

      Bruno