4 Replies Latest reply on Mar 9, 2017 8:43 PM by Dale Forman

    Rolling 12 Months calculation

    Dale Forman

      I need to count distinct values for rolling 12 months. But i need to show values on quarterly basis

       

      So if i say Mar 2017, Then it should take values from 1 Apr 2016  to 31 Mar 2017

        Dec 2016,                                                          from 1 Jan 2016  to 31 Dec 2016

        Sep 2016,                                                          from  1 Oct 2015 to 30 Sep 2016

       

       

      Using attached sample excel sheet  final values should be

      Mar 2017 # 4  (Distinct count of A,B,C,D)

      Dec 2016 #  5 (Distinct count of A,B,C,D,E)

      Sep 2016 #  3 (Distinct count of A,C,E)

       

      I have read many similar questions in forums and blogs.  I am sorry  ,if i am repeating already answered question.

       

      Thanks