Hi,
I have a pivot table which gives me exactly what I need until being asked with summing up the Cost variable by the JD Variable.
The table below, variable Total Job Cost, has been hard coded to hopefully help give an understanding of that it is I am after.
Any idea how I can create this...