I'm a newbie, sorry if this seems stupid, but can anyone help me, Ive the following query:
select PBDate, Datename(WeekDay, PBDate) as MyDay, Station, sum(CASE WHEN NG IS NULL THEN bcount ELSE 0 END) as Good, sum(CASE WHEN NG is not null THEN 1 ELSE 0 END) as [No Good]
from ProcessDetails where PBDate between '07/16/2018' and '07/20/2018'
group by PBDate, STATION
That gives me this result:
I want to achive this:
Since I'll be color coding the headers of Good->Yellow and No_Good->Light Blue, I don't actually need those headers.
I've try using pivot but so far no success, can some one please show me how to achieve this, it is very frustrating.
Thanks in advanced for your help