For the pivot, I posted something like what you are trying to do a little while ago..

http://www.sqlservercentral.com/Forums/Topic475805-338-1.aspx#bm476235

It shouldn't be too hard to switch it around for a quarterly summary too.