SQL Server Pivot Table with multiple column aggregates

Great example on how to pivot multiple columns and aggregates them and then continues by then doing it with a dynamic pivot. Also example is showing off a great tool called SQL Fiddle created by Jake Feasel.

http://stackoverflow.com/questions/14694691/sql-server-pivot-table-with-multiple-column-aggregates