• Why didn't you say so from the beginning?

    Read my article here http://www.sqlservercentral.com/columnists/plarsson/pivottableformicrosoftsqlserver.asp

    It has everything you need, including multiple aggregations.

     


    N 56°04'39.16"
    E 12°55'05.25"