4 Replies Latest reply on Apr 12, 2018 1:31 PM by Samanth Yadav

    Calculate New Clients added Month over Month

    Samanth Yadav

      Hi All,

       

      I have a date and client column. Every month there will be new clients added and few clients exiting from the existing clients. I need a calculation where if I select Jan 2018, I should be able to get the count of new clients added in the month of January 2018 when compared to Dec 2017. Similarly, if I select Feb 2018, I should be able to get the count of new clients added in the month of February 2018 when compared to Jan 2018. Similarly, if I select Dec 2017, count of new clients should be 0 as it is the starting month in our calculation.

       

      Attached is the workbook.

       

      Thank you.

       

      Regards,

      Sam