2 Replies Latest reply on Oct 29, 2018 6:44 PM by Shinichiro Murakami

    LOD Calculation Help

    vengadesh palani

      Hi ALL

       

      I have data like below table

         

      Existing business

      CustomerMonthSalesQuarter Flag
      A10/1/201810Existing business
      A9/1/20185

      New business

      A8/1/201810

      New business

      A7/1/20182New business
      B10/1/20185New business
      C9/1/20185Existing business
      C8/1/201810Existing business
      C7/1/20182Existing business
      C6/1/20184New business
      C5/1/20186New business
      C4/1/20184New business

       

      when I select a particular Month, dashboard want to show only Existing business customer information but it wants to show all records for last three-month value

       

      EX: I have selected August/2018 Month

       

      in August/2018 only C is the Existing business so it wants to show in the dashboard but in Last three-month sales value it wants to consider all recorded (Existing business+New business)

       

      How can i achieve this Logic

       

       

      temp .jpg

       

      Thanks.