Search the Community

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