Pivot count excluding duplicates

Hello,

I'm trying to do some reporting of team members performance and have been having trouble only reptoring on Unique numbers. Basically what I would like is be able to this data for the count of unique application IDs per user by date but can't work out what to change to exclude duplicates from my reporting, is this possible or would I have to manually copy the data and then remove the duplicates?

P.S The data is pivoted in other ways so I would prefer not to change the actual data

Thanks,

Example.xlsx