It could be I'm not being clear, trust me, that happens, lol.
The pivot table sums up what I need, I just need it to be in columns F and G in the second worksheet I attached. I.E., I need to have the Total 2011 and Total 2012 columns filled in in the same row as the (Employee Name) Total.
Your pivot table sums the data perfectly, it just isn't in the place on the worksheet where the head honchos want it to appear.
Hope that makes it more clear.
Bookmarks