Forum Discussion
Post PatronSorting Row Header According to Date
Post PatronHi!
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.
- newgirl
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.)