1 Reply Latest reply on Jan 19, 2018 4:18 PM by Shinichiro Murakami

    Customer lease 12 months

    Jagjit Singh

      Hi,

       

      I'm trying to create a monthly trend view to show the no of customer who survived more than 12 months starting from the previous financial year. The financial year should start from July.

       

      For example in FY 2018, only customers who started in FY 2017 should be included and then calculate how many survived >= 12 months. Similarly in FY 2017 the view should include only customers who started in the previous year ( i.e FY 2016) and then work out how many survived >=12months.

       

      I have attached a sample workbook

       

      Thanks

      Jag