Matrix - sort rows by values in specific columns
-
Hi,
in my report, i have one Matrix (no tablix) with position of players over the months.
And i want to sort row group by values in first column (in this case 2017/10). So the result will be this:
It's possible to do that with matrix? I tried many solution from internet, but nothing works.
The data source is just table with 3 columns: Player, Date, Position.
Thanks for any help. -
So, i found solution, for hardcoded name of column:
Sum(iif(Fields!Date.Value= "2017/10", Cint(Fields!Position.Value),0))
Unfortunately, i cant replace string "2017/10" with expression Max(Fields!Date.Value, "DatasetName") because it's inside Sum aggregation, and this will be invalid expression.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply