Forum Discussion
Sorting Row Header According to Date
Yes, you were right.
Add a column with a numeric index to you months (so jan is 1, feb is 2 etc). Then in Table view click on your column, go to Modeling and click on "Sort on column" (not sure how it's in English, somewhat similar to this). Then choose the column with numbers.
Hi!
I tried to do your steps. I added a new column and used =MONTH to get the numerical value for the date. I tried to insert this new column in the Rows but now the numbers are all being repeated.
Also, if I click the matrix and try to click the "Sort by Column", it's greyed out.
Do you other ideas?
No, you don't have to do it in the visual but in the table view.
Hi!
I read again your initial response. I opened the Data view, and added a new column representing 1 = Jan, 2 = Feb, and so on.... I sorted this column under Modelling Tab.
Going back to the Report view, I replaced the "Months" column with the new column.
However, this new column is still not being ordered in an ascending order.
Hope you have other ideas!
Two things
- your data is clearly still sorted on the amount, so clicks on the three dots and sort on month
BUT ALSO
- you don't have to use now the "number of month" column, just keep the original Month (Jan, Feb etc.)