Pivot table repeating rows in calculation

[Stephenosn]

Hello all,

I'm having trouble with a pivot table I'm trying to assemble. My intention is to have the pivot table display Job, Budget, Cost and Difference. My pivot table source is time card entries with equipment and labor costs. The sheet looks similar to the first sheet below.

[TABLE="class: grid, width: 800"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Job[/TD]
[TD]Task[/TD]
[TD]Task Budget[/TD]
[TD]Budget Remaining[/TD]
[TD]Equip $[/TD]
[TD]Labor $[/TD]
[TD]Total $[/TD]
[/TR]
[TR]
[TD]05/17/2017[/TD]
[TD]Miller[/TD]
[TD]Excavating[/TD]
[TD]$5,000[/TD]
[TD]$3,900[/TD]
[TD]$1,000[/TD]
[TD]$100[/TD]
[TD]$1,100[/TD]
[/TR]
[TR]
[TD]05/17/2017[/TD]
[TD]Miller[/TD]
[TD]Backfill[/TD]
[TD]$2,000[/TD]
[TD]$1,600[/TD]
[TD]$400[/TD]
[TD]$0.00[/TD]
[TD]$400[/TD]
[/TR]
[TR]
[TD]05/18/2017[/TD]
[TD]Miller[/TD]
[TD]Excavating[/TD]
[TD]$5,000[/TD]
[TD]$3,615[/TD]
[TD]$200[/TD]
[TD]$85[/TD]
[TD]$285[/TD]
[/TR]
[TR]
[TD]05/18/2017[/TD]
[TD]Miller[/TD]
[TD]Water Line[/TD]
[TD]$1,000[/TD]
[TD]$200[/TD]
[TD]$1,200[/TD]
[TD]$0.00[/TD]
[TD]$1,200[/TD]
[/TR]
</tbody>[/TABLE]

The pivot table I wish to create looks like the table below.

[TABLE="class: grid, width: 800"]
<tbody>[TR]
[TD]Job[/TD]
[TD]Budget[/TD]
[TD]Actual[/TD]
[TD]Difference[/TD]
[/TR]
[TR]
[TD]Miller[/TD]
[TD]$8,000[/TD]
[TD]$2,985[/TD]
[TD]$5,015[/TD]
[/TR]
</tbody>[/TABLE]

Easy enough, or so I thought. I can get the Budget column by using the Min value, but the Actual column eludes me. When I "Show Details" or "Drill Down" on the pivot table I see that a few rows repeat themselves, throwing my cost off. The drilled down detail look similar to my first table, but has one or two rows duplicated.
Is there any reason why rows would double themselves up? Is there any way to prevent this from happening?

I'm using Excel 2016 on Windows 10.

Thanks for having a look,

John

 

[Stephenosn]

Please ignore my post. I believe I've found the answer.

Thanks,
John