Use the aggregation function in a sort expression

Question

I have a report that uses a dataset returned from a stored procedure. There are two key columns: Name and Value

I use this dataset for two tables. The first is just a tab displaying data.

The second group of data is based on the Name column. I need to order this data based on the sum of the column Value

However, I get the following error:

[rsAggregateInDataRowSortExpression] A sorting expression for tablix "table1" includes a collection function. Aggregate functions cannot be used in data row sort expressions.

Is there any other way to show the data grouped by name and arrange it by its value?

Answer 1

OK, I just need to add an extra column for the Sum value in my query, and then use it. Not perfect, but it works

Answer 2

Instead of sorting in tablix, you need to sort against a group of strings. Remove the sort in tablix, and then go to the row group properties and put the same sort expression in the sort section there, then this should work.