Forum Discussion
Modify row order in the matrix view manually
Hello,
I don't see how to order manually the rows in the matrix view.
Is there any possibility to do it ?
Regards.
Having November or December 2015 show up after January-October 2016 would only happen if you ordered the column by Month Number with numbers 1-12. If you order the column by something like the first day of the month, or YYYYMM, then each month for each year will get its own number and can still be ordered sequentially. 201511 (Nov 2015) will still show in the list before 201601 (Jan 2016).
6 Replies
There's no way to drag them around and sort them that way, but you can use another column to define the sort order. For example, if you have Month names (Jan, Feb, Mar,...) and want them sorted in calendar order instead of the default alphabetical order, you would go into the Data view and select the Month Name Text column. Then in the Modeling tab of the ribbon, choose Sort By Column and select the column name that should be used to sort it, such as First Day of Month (1/1/2016, 2/1/2016, 3/1/2016,...).
