• Hi Paul,

    thanks for the correction of the typo.

    The query still works fine, but order year 2001 will be interpreted as 2002 .

    It should be like this:

    SUM(CASE when OrderYear = 2002 then SubTotal ELSE 0 end) as '2002',