Forum Discussion
Mel_G_01
Jun 01, 2021Copper Contributor
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 ...
- Jun 01, 2021Creating PivotTable add data to data model and next in Value Field Setting select Distinct Count Without data model this option is not available. 
SergeiBaklan
Jun 01, 2021Diamond Contributor
Creating PivotTable add data to data model
and next in Value Field Setting select Distinct Count
Without data model this option is not available.
- DenisaKlJul 31, 2023Copper Contributor- SergeiBaklanJul 31, 2023Diamond ContributorDenisaKl , you are welcome