count unique days and not rows/records.

[frankee_gee]

We have a simple pivot table with many rows of data.

We’ve been asked to count the number of days our workers used a specific work order number. We figure it would be easy, to simply count the number of unique days...nope. I counts the number of records...not unique dates

When I place the “Period Ending” as values…it counts all records /rows for that Work Order number.
I used a the smallest work order to test this. I get a count of 18 counting the rows and not the count of unique days. Had it counted unique days...I should show 9 days. How can I get the count of unique days. For each work order using a pivot table.

Thank you.

Frank

 

[BrianMH]

Try the techniques on here.

Unique Count in Excel Pivot Table With PowerPivot

 

[frankee_gee]

Brain,

Thanks Bro! This worked perfectly. Thank you so much, You Help is greatly appreciated!!!!

 

[BrianMH]

Glad to help.