4 Replies Latest reply: Dec 1, 2014 11:46 AM by Ron Sark RSS

    Count of Distinct Consultants each Month with Summation of Total Consultants

    Ashish Michael

      Hi,

           I want to count the Distinct Consultants falling each month with Summation of Total Consultants. Suppose I have Consultants C1,C2,C3,C4,Falling in Jan Month and C5,C6,C7,C8 falling in Feb Month. So the formula that be

      Count(<Month=Jan> Consultants)+Count(<Month=Feb> Consultants). So it must sum up Distinct Consultants Falling in each Month with their summation according to Number of Months in YTD.