May 5, 2009 at 1:14 pm
Hello, I'm having a bit of a ssrs sorting quandary. I need to sort columns by their totals.
Here is my query that I'm reporting off of:
Columns & Data:
fund | Central | Midwest | Northeast | Northwest | Southeast | Southwest
fund1 | 33080 | 23500 | 20000 | 0.00 | 0.00 | 1760
fund2 | 0.00 | 0.00 | 0.00| 0.00 | 50000 | 0.00
So then I created a matrix that has the totals included. This is working great.
How can I sort the following columns from highest to lowest:
Central | Midwest | Northeast | Northwest | Southeast | Southwest
so my report output would be:
fund | Southeast | Central | Midwest | Northeast | Southwest | Northwest |
fund1 |0.00 |33080 | 23500 | 20000 | 1760 | 0.00 |
fund2 |50000| 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
Total | 50000 | 33080 | 23500 | 20000 |1760 | 0.00 |
May 18, 2009 at 8:03 pm
Have you already tried changing the sort properties on the matrix? Matrix Properties > Groups > select column group > Edit... button > Sorting tab > enter expression such as =Sum(Fields!Amount.Value) > set sort Direction Descending.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply