Hi. I need to create a SQL statement using OVER(partition by..) in a CASE statement, as follows. Can't get the syntax correct though..
select (sum(case when dim1 = x and dim2 = y OVER (partition by key1, key2) then measure1 end) )
Error: Incorrect syntax near the keyword 'OVER'.
Any help appreciated!