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.

Date	Job	Task	Task Budget	Budget Remaining	Equip $	Labor $	Total $
05/17/2017	Miller	Excavating	$5,000	$3,900	$1,000	$100	$1,100
05/17/2017	Miller	Backfill	$2,000	$1,600	$400	$0.00	$400
05/18/2017	Miller	Excavating	$5,000	$3,615	$200	$85	$285
05/18/2017	Miller	Water Line	$1,000	$200	$1,200	$0.00	$1,200

<tbody>
</tbody>

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

Job	Budget	Actual	Difference
Miller	$8,000	$2,985	$5,015

<tbody>
</tbody>

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