Count the no of jobs with multiple dates

[sn152]

Hi All,

I have a sheet many lineitems. Now Iam trying to put a pivot for this to find the count the no of jobs with multiple dates and segregate it team wise.
Please help me with this.

Thanks in advance !

 

[Somendra Misra]

Hi sn152,

Doesn't only keeping the dates in row labels will serve your purpose?

Regards,

 

[sn152]

Hi Somendra,

I just need the no. of jobs with multiple dates. One job might have multiple dates. So I need the count of those jobs according to team wise.

Thanks!

 

[Somendra Misra]

@sn152

Something Like this.



OR



Regards,

 

[sn152]

But I want the job ids in the row labels and count of date in values and the team in column labels... is that possible....

 

[Somendra Misra]

Something like this. Note this is counting duplicates.



Regards,

 

[sn152]

Yes this is correct. But I want to filter all the values in the grand total which is greater than 1. This should be done in pivot table itself. Is that possible?

 

[Somendra Misra]

In Job ID drop down select value filter and give your condition.

Regards,

 

[sn152]

Coool... Thank you so much Somendra....