SSRS report - Matrix columns grouping and sorting

Question

I have a matrix that looks like this:

Parameter X Y Z

A 0 1 1
B 0 1 1
C 0 1 1

Which I want to add a column sorting to. I want to put column X all away to the right based on a fact that it has all zero values. It's important to ensure that all values are zeroes before sorting. Any idea how to do it?

Thanks

Answer 1

Hi @mark goldin ,
You just need to set the sorting in the column group properties. My matrix looks like the image below:

Click [Type] in Column Groups, right-click to select Group Properties, and click the Sorting option. The settings are as follows:

Preview:

Best Regards,
Joy

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

I think have a problem with group sorting when I am exporting report to Excel. I am running reports i Local Mode - no SSRS server. The exported Excel file is not showing group sorting. The same report exportrd on the SSRS server has a proper sorting. Any idea?