select case totals

Hi, when using a select case query how can I get a total row calculation of columns.  Here is an example of the code I am using.
select a.item1,
      sum (case
when a.item1 in ('value1', 'value2', 'value3')
      then 1
      else 0
            end) as 'abc',
      sum (case
when a.item1 in ('value1', 'value2', 'value3')
      then 1
      else 0
      end) as 'def',
from tbl1 as a join tbl2 as b
on a.item1 = b.item1 where datepart(dd, getdate()) = datepart(dd, datefield1)
and b.item2 is not null and reasoncode IN ( 'g', ' h',  'i',  'j' )
group by a.item1
marcus72Asked:
Who is Participating?
 
imran_fastConnect With a Mentor Commented:
Whats wrong with the above code?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.