Hi, I have a list that collects a large amount of data including a date of event.
From this, calculated columns convert the date field into
A "Financial Year" month NUMBER where April = 1 A TEXT month such as April A "Group by Month" column that combines the above so that a "grouped" view is sorted in the correct order (1 - April, 2 - May...)
Unfortunately options 2 and 3 are text fields and get sorted as such (1 - April, 10 - January, 11 - February, 12 - March, 2 - May...).
Is it possible to group a chart by the Displayed Month (Option 2) but sort it by Financial Year month NUMBER (1, 2, 3 ...)?
Thanks
Simon