Post reply

Matrix - sort rows by values in specific columns

  • November 13, 2017 at 5:52 am

    #340443

    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.

  • November 13, 2017 at 7:40 am

    #1967784

    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 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply