Matrix column custom sorting via Task finish date (MS project data field)
I hope someone can help
I have a matrix table which shows key points through my project with information whether those points are complete etc...
I would like to sort the columns by a date column (Task finish date) but I get the error "We cant sort the 'taskName' column by 'TaskFinishDate'. There can't be more than one value in 'TaskFinishDate' fr the same value in 'TaskName'".
I did have a work around where I used a calculation to create a sort column based on the name of the task. However this only works if the key points are consistant for all projects which unfortunately they are not.
I have managed to sort by using a unique task ID column and sorting that by finish date. This solves one problem, however, I now need to have this number in the matrix table title for the ordering to work.
Is there a way to hide this top tier of titles without it affecting the order of the table?