hi,
I have a dataset with columns: date(daily), year, season, data1, data2,....etc.
I have a simple query to sum the data cloumns by season for each year. However this puts the years in ascending order but the seasons in alphabetical order (Autumn, spring, summer, winter). Is there a way to force the output of the query to be a set order (Summer, Autumn, Winter, Spring)?
Thanks,
(ps. yes, I do want summer first as this is southern hemisphere seasons)
Bookmarks