Adding additional field to pivot table (but not for each column)

Good Morning,

I am currently using a pivot table to aggregate some labour-hour figures for various work centres, based on an imported list of operations being performed at those work centres.

Capture.PNG

These figures are generated by summing the work-hours for each work centre, grouped by job number.

For instance, job number 12345 might have:
12345 - clad - 12 hours
12345 - clad - 10 hours
12345 - CNC - 10 hours
12345 - Inspection - 10 hours

Which would be grouped into 12345 - clad = 22, CNC=10, Insp=10, Total = 42

However, what we want to do is add an extra column for the sales order value to this table.

The SO Val is the same for all jobs listed under 12345 - so using the max/average/min aggregate on the "value" field gives you the right value.

However, when I try to add this in, it always adds either an extra column per work centre, as can be seen here: note I have changed the "Total" value to a "count" field to obfuscate the actual cost of jobs

Capture2.PNG

What I want to do is display this value at the end of each line, beside the "grand total" column.




Any ideas how I might go about adding that last column in (preferably without using PowerPivot)

Many thanks in anticipation!