Pivot Table Unique Counts

[plum]

Hi there,

I have data which I have created pivot tables to count the number of 'defects' based on specific criteria.

For example - for pivot table A I have a count of:
week1 - 3 defects
week 2 - 4 defects
week 3 - 8 defects

For pivot table B I have a count of:
week1 - 7 defects
week 2 - 6 defects
week 3 - 9 defects

What I want to know is over all pivot tables how many of the count is unique based on a job number? Note - the counts are based on job number in the pivot table.

for example there may be no duplicates in week 1, so week 1 has a total of 10 defects. week 2 has three duplicates so there is a total of 7 defects.

Does this make sense?

I've attached a screen grab for reference of what I am looking for.

Thanks