SSRS, Limit Fixed number of Columns in Matrix within a Tablix - issue in sorting matrix data
I have managed to resolve this issue, thought i'll be helpful for others. The order needs to be on the main tablix and not on the inner group or Matrix.