Forum Discussion
Count of Date in Pivot Table
Hi All, I would like to COUNT the number of days worked within this pivot table, but it is counting every line entry date. For example this Job number is showing 12 days where it should be showing ...
Creating PivotTable add data to data model
and next in Value Field Setting select Distinct Count
Without data model this option is not available.
Thank you for your suggestions.
I have managed to get the information by including a formula into the data spreadsheet which counted only when the date changed, then refreshed the pivot table so that it showed the actual number of days worked.
