Forum Discussion
Sort by columns not working in matrix
In a matrix view, i used a measure in values for a report. In the report if i sort the report by this measure, this doesnot work. Pls help.
Anonymous said "There is no way of sorting a matrix visual by a column not being displayed."
I found a way to not display my sort value because the the table in my matrix has a fixed number of lines. So I simply shrank the visual height to cause the bottom line to always be off the visual and thus it is sorted and not displayed. The only hangup is there is a vertical scroll bar on the far right that is always displayed.Sorted ColumnsHidden Sort Value