How to sort SSRS Matrix report by Grand total field

Question

I created a matrix report. The report looks like this:

enter image description here

I want to sort the output so the region with highest sales should come on top.

e.g. From the above report South should show on top then West, Central and East.

How can this be done in SSRS (2008R2)?

score 9 · Accepted Answer · answered Feb 06 '15 at 17:15

9

You should just need to change your sort expression in the Group Row properties. Should be something like

=Sum(Fields!YourFieldHere.Value)

answered Feb 06 '15 at 17:15

1 Answers1