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:
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?
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:
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?