[
^]
[
^]Please find below query
select 'Closed' as 'Medium',
sum(case when Medium='Application' then 1 else 0 end) 'Application',
sum(case when Medium='E-mail' then 1 else 0 end) 'E-mail',
sum(case when Medium='Phone' then 1 else 0 end) 'Phone',
sum(case when Medium='Visit' then 1 else 0 end) 'Visit',
sum(case when Medium='Web' then 1 else 0 end) 'Web',
sum(case when Medium='Application' then 1 else 0 end)+
sum(case when Medium='E-mail' then 1 else 0 end)+
sum(case when Medium='Phone' then 1 else 0 end)+
sum(case when Medium='Visit' then 1 else 0 end)+
sum(case when Medium='Web' then 1 else 0 end) as 'Total'
from im_ticketmaster where status='Closed'
union
select 'Resolved' as 'Medium',
sum(case when Medium='Application' then 1 else 0 end) 'Application',
sum(case when Medium='E-mail' then 1 else 0 end) 'E-mail',
sum(case when Medium='Phone' then 1 else 0 end) 'Phone',
sum(case when Medium='Visit' then 1 else 0 end) 'Visit',
sum(case when Medium='Web' then 1 else 0 end) 'Web',
sum(case when Medium='Application' then 1 else 0 end)+
sum(case when Medium='E-mail' then 1 else 0 end)+
sum(case when Medium='Phone' then 1 else 0 end)+
sum(case when Medium='Visit' then 1 else 0 end)+
sum(case when Medium='Web' then 1 else 0 end) as 'Total'
from im_ticketmaster where status='Resolved'
union
select 'Pending' as 'Medium',
sum(case when Medium='Application' then 1 else 0 end) 'Application',
sum(case when Medium='E-mail' then 1 else 0 end) 'E-mail',
sum(case when Medium='Phone' then 1 else 0 end) 'Phone',
sum(case when Medium='Visit' then 1 else 0 end) 'Visit',
sum(case when Medium='Web' then 1 else 0 end) 'Web',
sum(case when Medium='Application' then 1 else 0 end)+
sum(case when Medium='E-mail' then 1 else 0 end)+
sum(case when Medium='Phone' then 1 else 0 end)+
sum(case when Medium='Visit' then 1 else 0 end)+
sum(case when Medium='Web' then 1 else 0 end) as 'Total'
from im_ticketmaster where status='Pending'
for the above query output is
Medium Application E-mail Phone Visit Web Total
Closed 0 0 0 0 1 1
Pending 0 0 2 0 4 6
Resolved 2 0 36 0 489 527
but need the output like below
Medium Application E-mail Phone Visit Web Total
Closed 0 0 0 0 1 1
Pending 0 0 2 0 4 6
Resolved 2 0 36 0 489 527
Grand Total 2 0 38 0 494