Pivot Table : Planned and Actual Count Over Same Time Period

That was a new level of insight to the data...

Yes, I think that's important. For example, looking at the way you set up the data, you planned 50 for march and did 45. that doesn't sound so bad. That's a good way to see if you are working to capacity. However, looking at my pivot table, the ones that were planned weren't done until April and May. This means you are constantly working on backlog. Data like this supports hiring temporary help (or approving overtime) to remove backlog.