Have you created a split column for the months of a year but they are ordered alphabetically?

If you would like to achieve a result similar to the image below (click to enlarge), then this forum post will help!

Workbooks will arrange split columns alphabetically, therefore, when you want to split by the month you must include the numerical value for them to order chronologically.

This does not mean that you cannot also include the month name! This can be achieved with a concatenated column.

In our example above, we use the following formula:

• CONCAT_WS(' - ', DATE_FORMAT(close_date, '%m'), DATE_FORMAT(close_date, '%M'))

You would change the 'close_date' to the date that is of interest to you, this can be done with the formula builder by selecting the column you want.

Now when creating your split column, you will use this concatenation as your 'split by' column. Now you have the month names appearing in the correct order.