count unique dates in pivot table

[HerrSober]

Hi!

I have the following table (copy paste to Excel to get correct formatting):

[TABLE="width: 289"]
<tbody>[TR]
[TD]Date [/TD]
[TD]Employee[/TD]
[TD]Item[/TD]
[TD]Sales[/TD]
[/TR]
[TR]
[TD="align: right"]01/01/2015[/TD]
[TD]Jack[/TD]
[TD]Horses[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]01/01/2015[/TD]
[TD]Jack[/TD]
[TD]Cars[/TD]
[TD="align: right"]43[/TD]
[/TR]
[TR]
[TD="align: right"]01/02/2015[/TD]
[TD]Hans[/TD]
[TD]Horses[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]01/02/2015[/TD]
[TD]Jack[/TD]
[TD]Cars[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]01/02/2015[/TD]
[TD]Jack[/TD]
[TD]Houses[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]01/03/2015[/TD]
[TD]Jack[/TD]
[TD]Cars[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]01/04/2015[/TD]
[TD]Hans[/TD]
[TD]Houses[/TD]
[TD="align: right"]4[/TD]
[/TR]
</tbody>[/TABLE]

I want to create a calculated field (pivot table) which counts the unique days in this table.
Anyone knows how to do it?

Best regards
Sober

 

[jorismoerings]

Hi,

take a look at this link. It describes exactly what you need.
http://blog.contextures.com/archives/2014/05/20/unique-count-in-excel-pivot-table/