Forum Discussion
date Sorting
Thansk Again Phil.
I will remove Weeks and then only use Month/Year and DD fields.
I went to the modeling tab and sorted the data by M/Y Sort. It did the trick. Thanks again
Thanks Phil. I will make sure I have a date table connected . But it is strange that it worked the other day using those formulaes.
There wasnt any problem with February going prior to January!!!!
Regards
Another thing I notice is that your hierarchy has Month then Week.
Weeks don't always play nicely with Months given they don't share clean boundaries. This can often cause issues depending on how the weeks are linked to the months.
Note here how the 5th week in June 2016 also includes some dates from July. There is a small chance this can be upsetting your sorting.
Thansk Again Phil.
I will remove Weeks and then only use Month/Year and DD fields.
I went to the modeling tab and sorted the data by M/Y Sort. It did the trick. Thanks again
Cool, Nice work