I need to have an other value instead of FULL and NONE but I must do it in the select.
SELECT Calendar_Month,Series,Cnt
FROM T_Cust_Eom_n
where TYP='REB'
and Series='FULL'
or TYP='REB'
and Series='NONE'
order by Series desc,Calendar_Month
Can I do this with an as anyhow?
Here is what you want: