Forum Discussion
Sorting Row Header According to Date
Hi! I have in my report a matrix table showing the "Employee Name" as Rows and "Type of Expense" as Columns. This needs to be sorted in a descending order to know the top employees incurring exp...
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.)