November 13, 2017 at 5:52 am
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy