I have been through the forum and have found many useful ways of sorting especially the post about sorting within a group dimension. Even so I am struggling with the group I have created in the attached example. The group is multilevel and needs to be sorted as follows:
1> Quarter-Year , needs to be sorted logically by year-quarter
2> TPP - Sort order is HCD,ECD,DCD,SCD (always does not matter what numbers they show except if one is 0)
3> Month - Logical
4> Days of the month - Logical
I have spent several hours trying to test this to be correct. Any help appreciated. MAny thanks.
Each of the fields in the group have thier own sort behavior. If you edit your group, there is a 'sort order' button at the bottom of the window. You can define how each of your various group conditions will sort.
You also need to turn off 'override group sort' which you have selected in a number of your charts.
