Hi,

I have a Matrix in RS and I would like to sort the data fields based
on a header. I've been searching for an answer to this and it appears
it's a common frustration.

All I'm doing:

1. Dragging a data field into the table - it automatically adds the
sum(datafield) and automatically creates a header for this column.

2. Right-Clicking the header cell and going to properties >
interactive sort.

3. Selecting the data field I just dragged-and-dropped as my sort
expression. Not the sum of the datafield, just the datafield.

I get the arrows to appear on the header properly, but clicking them
to sort does nothing. I am following the steps exactly as this video
describes:

http://www.asp.net/learn/sql-videos/video-113.aspx

I have tried all possible variations of the above - changing scopes,
trying to do it by the sum, etc and nothing works. Can anyone help me?