<div>
Don't know about SSRS, but it is possible in the T-SQL data set that feeds it by using the SQL Server <a href="https://msdn.microsoft.com/en-us/library/ms175126.aspx" rel="ugc nofollow">NTILE() function</a>. &nbsp; (SQL 2012 and higher)<br />

<pre><code id="code-20-41830294-1">SELECT ID, Department, Average, 
    NTILE(5) OVER(ORDER BY Average DESC) AS Quintile
FROM YourTable</code></pre>
</div>


Don't know about SSRS, but it is possible in the T-SQL data set that feeds it by using the SQL Server NTILE() function [https://msdn.microsoft.com/en-us/library/ms175126.aspx].   (SQL 2012 and higher)


SELECT ID, Department, Average, 
    NTILE(5) OVER(ORDER BY Average DESC) AS Quintile
FROM YourTable

<div>
I'm looking for in SSRS expression
</div>


<div>
<div class="content wysiwyg-content">
How to calculate Quintiles value in SSRS. I want to calculate the Quintiles base on average field.<br />
<br />
My table is as below<br />
Select ID, Department, Average
</div>
</div>


How to calculate Quintiles value in SSRS. I want to calculate the Quintiles base on average field.

My table is as below
Select ID, Department, Average

how to calculate Quintiles in ssrs

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.