Pivot Table - No of Days Worked

[nbkjytr]

Hello Everyone,

I have couple of associates working during the weekend due to heavy backlog. They Maintain maintain their daily work records in Excel which I consolidate daily. Now some of them have worked on multiple weekends. Using a pivot table how can I know who worked how many days.
Because of multiple entry in Excel under the same date... I can pull up the name but the counts are coming for all their entries in Excel.

Exampl:-
Mr A worked on 20 orders on Saturday
Mr B worked on 15

Mr A worked on 25 orders on Sunday
Mr C worked on 20 orders on Sunday

Mr A worked on 55 orders on Holiday
Mr B worked on 30 orders
Mr C worked on 15

Now the considered file of Mr A shows total 100 orders against him.

But I just want the pivot to show how many days Mr A worked.

 

[severynm]

Hello,

Look at changing your aggregation. Instead of "Sum of orders" you want "Count of Orders" (or, to be more precise, change this to "Count of Days"). From your order field in the pivot table, go to its settings, and change the summarization from Sum → Count.

That gets us the pivot table below.