- Last Active
I thing I had to do was create a new field which took the date field and set the day to the first of the month. That way, all rows occuring in the month of october 2018 show up as 10/1/2018. That way I do not need to use the date grain and I can sort. It stinks, but they are working on the bug.
I am having the same problem. I can sort dates, text, numbers, etc. But if I use a date grain I am unable to sort.