The code I am using is to get the output data is below. IT gives me the sample output. The only problem, of course, is it captures all vendors when I only want vendors who have > 60 contracts in a year. I think that will show how I am getting those count numbers.drop table #temp1 select a.FICO_Nbr, b.vendor_name, [Contract_Count] = case when Contract_Received_Date is not Null then 1 else 0 end, [Application_Count] = case when Initial_Received_Date is not NULL or Approval_Status_Ind = 'Y' then 1 else 0 end, [Ficoband] = (CASE WHEN FICO_Nbr IS NULL OR FICO_Nbr = 0 THEN ' Missing' WHEN FICO_Nbr <= 500 THEN ' <= 500' WHEN FICO_Nbr BETWEEN 501 AND 600 THEN ' 501 to 600' WHEN FICO_Nbr BETWEEN 601 AND 700 THEN ' 601 to 700' WHEN FICO_Nbr >= 701 THEN ' 701 +' END) into #temp1 from Vw_Application_Dim a inner join vw_vendor_dim b on a.vendor_key = b.vendor_key where Initial_Received_Date between '2012-01-01' and '2013-01-01' select vendor_name, [Ficoband], Apps = count(case when [Application_Count] = 1 then [Application_Count] else null end), Contracts = count(case when [Contract_Count] = 1 then [Contract_Count] else null end) from #temp1 group by vendor_name, [Ficoband]union select vendor_name, [ficoband] = ' Total', Apps = count(case when [Application_Count] = 1 then [Application_Count] else null end), Contracts = count(case when [Contract_Count] = 1 then [Contract_Count] else null end) from #temp1group by vendor_nameorder by vendor_name