Forum Discussion
Solved
Formatting custom date hierachy
Hi All, I am using a matrix to display the total hours worked per day by resource. For the columns, i have a date field and have used 4 custom fields that extract the Week, Month, Year...
Hi SamWhitehouse ,
Based on the description you have made I assume you have a month number and a month name on your table make the sorting of month name by the month number column:
Regards,
MFelix
In your date table you should have two columns, one that represents the month in text and one that represents the number of the month.
Once this is in place you select the text column of the month, in the ribbon there is a "Sort by column"-button from which you can select the month number. When this is done the month names will be sorted according to the number.