count unique dates in pivot table

[HerrSober]

Hi!

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

Date	Employee	Item	Sales
01/01/2015	Jack	Horses	2
01/01/2015	Jack	Cars	43
01/02/2015	Hans	Horses	4
01/02/2015	Jack	Cars	5
01/02/2015	Jack	Houses	3
01/03/2015	Jack	Cars	2
01/04/2015	Hans	Houses	4

<tbody>
</tbody>

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/