Thanks so much. I am just learning the crosstab function and sometimes can't see the trees for the forrest.

I put that right below pvt; and it says Incorrect syntax near the keyword 'WHERE'