SSRS 2008 R2 Insert Column outside group-Left is not working

Question

I am building an SSRS report, that contains a Date column, a value column, and a row number column, The rows must be grouped by Date, and I managed to achieve this by creating a group based on the Date column, please check the image:

Now I just want to move the "SN" (Row number) column to the left to become the first column, I am doing this by right clicking on the time stamp column, and selecting "Insert column outside group-left", but this is not adding the column outside the group, the new column is being grouped inside the Time Stamp group:

Any idea on how to move the right SN column to the left of the Date column, without merging it into the group. Thanks

Answer 1

To keep it simple. You can create a new dataset selecting SN and Timestamp,order by timestamp.Now create a new tablix and select only SN field in it from the new dataset.Now merge the old tablix and the new one.