Pivot Table Help

[tbakbradley]

I have a Pivot Table with the following:

Column Labels: "On Time or Late" (This is a Column that calculates if a job was On Time or Late with those words)

Row Labels: "Employee Name" Column and "SOURCE" Column (job category)

Values: Count of SOURCE

This gives me a table that shows:

First Column = Employee Name and under it the SOURCE (job category)

Second Colum = Number of "Late"

Third Column = Number of "On Time"

Fourth Column = Grand Total (Late + On Time)

I would like Fifth column in the Pivot Table to show % On Time. I've tried adding "SOURCE" to the values and Calculate as % of Row, but it gives me way more than I want and its confusing.

Is there a way to do this?

Thanks for any assistance

Fourth Column =

 

[tbakbradley]

Bumping this up to make sure it doesn't get lost. I hope my description made sense.

 

[tbakbradley]

Edit- I accidentally posted this twice