<div>
Could you please post the screenshot of your result ?<br />
<br />
And Post a screenshot for Desired result.
</div>


Could you please post the screenshot of your result ?

And Post a screenshot for Desired result.

<div>
Sure.... Always want the most recent year to be sorted discerningly.<br />
This is what I'm getting....<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/06_w23/1166194/Capture_Current.JPG" target="_blank" title="Capture_Current.JPG (24 KB)"><img alt="Capture_Current.JPG" class="file-block lazyload" style="max-width: 334px;" data-src="https://filedb.experts-exchange.com/incoming/2017/06_w23/1166194/Capture_Current.JPG" /></a><br />
This is what I want....<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/06_w23/1166195/Capture_Desired.JPG" target="_blank" title="Capture_Desired.JPG (23 KB)"><img alt="Capture_Desired.JPG" class="file-block lazyload" style="max-width: 329px;" data-src="https://filedb.experts-exchange.com/incoming/2017/06_w23/1166195/Capture_Desired.JPG" /></a>
</div>


Sure.... Always want the most recent year to be sorted discerningly.
This is what I'm getting....
Capture_Current.JPGhttps://filedb.experts-exchange.com/incoming/2017/06_w23/1166194/Capture_Current.JPG
This is what I want....
Capture_Desired.JPGhttps://filedb.experts-exchange.com/incoming/2017/06_w23/1166195/Capture_Desired.JPG

Capture_Current.JPG

Capture_Desired.JPG

<div>
<div class="content wysiwyg-content">
Hi all,<br />
I have matrix in an SSRS report (2012) with the following fields....<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/06_w23/1166191/Capture.JPG" target="_blank" title="Capture.JPG (9 KB)"><img alt="Capture.JPG" class="file-block lazyload" style="max-width: 173px;" data-src="https://filedb.experts-exchange.com/incoming/2017/06_w23/1166191/Capture.JPG" /></a><br />
I am trying to figure out how to sort on the Count column. &nbsp;It is sorting desc on the Person_Name column. &nbsp;the SQL string is ordering by COUNT DESC.<br />
<br />
Thanks for anyone's help,<br />
John.
</div>
</div>


Capture.JPG

Hi all,
I have matrix in an SSRS report (2012) with the following fields....



I am trying to figure out how to sort on the Count column.  It is sorting desc on the Person_Name column.  the SQL string is ordering by COUNT DESC.

Thanks for anyone's help,
John.

SSRS Matrix Object

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.

SSRS

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.