Modify row order in the matrix view manually

[zoubaier]

Hello,

I don't see how to order manually the rows in the matrix view.

Is there any possibility to do it ?

Regards.

[KGrice]

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,...).

[zoubaier]

Thanks for your answer, but it will not work for me as i have different months of multiple years.

[sdjensen]

@zoubaier Could you please elaborate what you are trying to do - perhaps share a bit about your data and the model you build.

[zoubaier]

You can find an example of column i want to order

If i use another column with month number, november and december of 2015  will be after  2016 months.

[KGrice · Accepted solution]

@zoubaier

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).

[zoubaier]

@KGrice Thanks it works with this format.