<div>
Try this<br />

<pre><code id="code-1649025">select 
sum(case when possibility = 'aaa' then 1 else 0 end) possaaa,
sum(case when possibility = 'bbb' then 1 else 0 end) possbbb,
sum(case when possibility = 'ccc' then 1 else 0 end) possccc,
sum(case when possibility = 'aaa' then 1 else 0 end) + sum(case when possibility = 'bbb' then 1 else 0 end) + sum(case when possibility = 'ccc' then 1 else 0 end) posstotal
from your_table
</code></pre>
</div>


Try this


select 
sum(case when possibility = 'aaa' then 1 else 0 end) possaaa,
sum(case when possibility = 'bbb' then 1 else 0 end) possbbb,
sum(case when possibility = 'ccc' then 1 else 0 end) possccc,
sum(case when possibility = 'aaa' then 1 else 0 end) + sum(case when possibility = 'bbb' then 1 else 0 end) + sum(case when possibility = 'ccc' then 1 else 0 end) posstotal
from your_table


<div>
Sameer,<br />
<br />
There seems to be some missing information on line five at the end.
</div>


Sameer,

There seems to be some missing information on line five at the end.

<div>
<div class="content wysiwyg-content">
In my VarChar Column, &nbsp;'ZZ', &nbsp;I have 3 &nbsp;possibilities with a total of 134 rows :<br />
<br />
Possibilities<br />
1. &nbsp;aaaa<br />
2. &nbsp;bbbb<br />
3. &nbsp;cccc<br />
<br />
I need to create a table to show a total of each of these possibilities that are listed.<br />
<br />
Example:<br />
aaaa &nbsp; &nbsp;bbbb &nbsp; &nbsp;cccc<br />
&nbsp;53 &nbsp; &nbsp; &nbsp; &nbsp; 47 &nbsp; &nbsp; &nbsp; &nbsp;34 &nbsp; &nbsp; &nbsp; &nbsp;TOTAL<br />
`<br />
Please provide an expression that I can use to obtain each of &nbsp;the 3 &nbsp;totals.
</div>
</div>


In my VarChar Column,  'ZZ',  I have 3  possibilities with a total of 134 rows :

Possibilities
1.  aaaa
2.  bbbb
3.  cccc

I need to create a table to show a total of each of these possibilities that are listed.

Example:
aaaa    bbbb    cccc
 53         47        34        TOTAL
`
Please provide an expression that I can use to obtain each of  the 3  totals.

How can  I sum a column as an expression?

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.