Pivot table to ignore duplicates

[sknight22]

Hello

I am logging training cards on a spreadsheet daily. They are all number SCU001, SCU002 and on and on and every time someone visits I log their card number against the date of visit.

Is it possible to have a pivot that shows the date then the count of new cards issued that day? I am not sure how to stop it counting repeat visitors as I only want a count of new cards issued that day.

Is it possible for it to ignore the number if it already appears in the data on an earlier date?

Thanks

 

[SpillerBD]

Set a date filter or slicer.
Date filter in the pivot Table has a TODAY option.

 

[sknight22]

Thanks, I dont want it to count repeat visitors though so I just want a report of how many new ID numbers per day. So if SCU001 was given out on 1st Nov I only want it to show in my results for 1st Nov and not on the following days that the number shows up, if that makes sense