Forum Discussion
Sorting by column and value
Hello,
is it somehow possible to sort rows by selecting one of those values (measures) below years? If I remove year from columns I can sort rows but haven't figured out how to sort rows by year AND one of those measure values. Thanks.
Hi Testeri
In the matrix can only be sorted by rows or a certain value, can not achieve columns and measures to sort the matrix, when you place the year value in the column, it is sorted in ascending order by default, at this time can only be arranged according to one of the measures, click the "..." next to the matrix, then select sort by, then select a measure, and select the sort order, is ascending or descending, as shown in the figure.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Testeri
In the matrix can only be sorted by rows or a certain value, can not achieve columns and measures to sort the matrix, when you place the year value in the column, it is sorted in ascending order by default, at this time can only be arranged according to one of the measures, click the "..." next to the matrix, then select sort by, then select a measure, and select the sort order, is ascending or descending, as shown in the figure.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ok, thanks.
