Hello,

i would work in 3 steps to simulate the excel pivot.

1. As there are 2 row headers and an extra one for the measuretype 'value', i would group the base...

Hi

often i have the same issue. If there is no absolute need for the result being a char, but an integer value is ok too, then i use

SELECT Year(testdate)...