1 Reply Latest reply on Jan 4, 2017 9:46 AM by Bridgette Burlingame

    new records count based on month difference

    Suresh Babu Kommuri

      Hello All,

       

      I am struggling in the below requirement, could you please help me.

       

      I have below columns

      Dimensions

      Wholesalers

      date as using Month(date)

      Customer ID as using countd(ID)

       

      I want to find new customers based on below business rule.

      if customer ID for the month of Nov not exist in Oct then they are new customers same like who exist in Dec not in Nov.

      Could you please suggest.

      DateDate
      existing customersNew customers
      WholesalersOctNovDecOctNovDec
      Tesco10010198015
      Walmart

       

      Advanced Thanks

      Suresh