Use an Aggregate function in Sort Expression

Question

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

I am using this dataset for two tablixes. The first is just a straightforward tablix displaying the data.

The second groups the data based on a Name column. I need to order this data based on the Sum of Value column

However I get the following error:

[rsAggregateInDataRowSortExpression] A sort expression for the tablix 'table1' includes an aggregate function. Aggregate functions cannot be used in data row sort expressions.

Is there another way I can show the data grouped by name and still order it by Sum(Value)?

Answer 1

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