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

# Count of Distinct Consultants each Month with Summation of Total Consultants

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.

• ###### Re: Count of Distinct Consultants each Month with Summation of Total Consultants

Hi,

I'm not sure, but maybe the attached qvw works

• ###### Re: Count of Distinct Consultants each Month with Summation of Total Consultants

Hi Michele,

The example you have shown is simple Count of Consultant. But I want Individual Count of Consultant for Each Month as per the YTD. As per Current YTD there are 11 Months.So it must Distinct Count for each Month with Summation for 11 Months Count. I have illustrated the example in Snapshot.

• ###### Re: Count of Distinct Consultants each Month with Summation of Total Consultants

Something like this?

if(dimensionality()=0,

sum(aggr(count(distinct Consultant), Month)),

aggr(nodistinct count(distinct Consultant), Month)

)

• ###### Re: Count of Distinct Consultants each Month with Summation of Total Consultants

Hello Ashish,

You may be able to accomplish the same result by creating a resident table similar tothe attached Script