Pivot Table Without Duplicate Values

Hello,

I am trying to create a pivot table that will not repeat the values of a certain column. The table below shows and example of the data I am working with.

Pivot Table Data.PNG

Looking at this data my objective is to be able to select a Date and Program and get the value for Total Parts Produced (Total Parts Produced is the sum of Total Line Rejects & Total Good Parts).

For Example: If I select 8/1/16 & P558 Main FE this is what I am wanting the pivot table to do...

Total Line Rejects = 0+3+1=4 (I was able to create this column in the pivot table[see below], just can't figure out the rest)
Pivot Table Data 2.PNG

Total Good Parts = 350+202=552

Total Parts Produced = 4+552=556

I appreciate any help I can get. Thanks!

ok, how should I do this?

When I drag this formula down the row it doesn't seem to work right.

I am having a hard time wording what it is I am needing I think. If I choose 8/1/16 as my date and P558 Main FE as my program then...

Column A & D have 3 options for 8/1/16 & P558 Main FE

but Column B only has 2 because I only need 1 per shift. It displays 1,2,2 and don't need a repeat of 2. Therefore, I would only need to sum H26 & H44 giving me a Total Good Parts value of 552.

Here is the file I am currently working on...

P558 Defect Tracking Pivot Table 2.xlsm

Thank you so much! This worked perfect!

I am having issues again. I have attached the file for you to look at if you have time. P558 Defect Tracking Pivot Table 2.xlsm

I can't seem to get the correct total for Total Good Parts.

For example, P558 LTR FE - 8/1/16 - should be 591 NOT 941 (This is in the Total Parts_TLR tab)
350+360+231=591

I'm not sure where the 941 is coming from. I would appreciate any help you can give me. Let me know if you have any questions. I am new to pivot tables so I apologize if what I'm asking might seem confusing.

You are correct I apologize. I forgot to add the other number to it. I should have walked away for the day and come bad today with a clearer mind. Thanks again!